There is already an open DataReader associated with this Connection

Discussion in 'ASP .Net' started by James Brown, Jun 26, 2003.

  1. James Brown

    James Brown Guest

    I have an ASP .NET application. [VS 2002, .NET Framework 1.0 SP2]

    In the application, if I execute a long running query (which may time
    out or something I guess) from one browser window, and in another
    instance of the same web application in another browser window,
    execute a very quick query, I get the above error message.

    I have noted the fix at:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319345

    But I already have Service Pack 2 installed. Please help!

    Thanks in Advance
    James
    James Brown, Jun 26, 2003
    #1
    1. Advertising

  2. James Brown

    bruce barker Guest

    bug in your code.

    you probably have a connection defined a static variable (shared or public
    in a module in vb.net). this would lead to the same connection being used by
    all page requests (even concurrent), and as a connection only supports one
    active query at a time, you get this error.

    -- bruce (sqlwork.com)

    "James Brown" <> wrote in message
    news:...
    > I have an ASP .NET application. [VS 2002, .NET Framework 1.0 SP2]
    >
    > In the application, if I execute a long running query (which may time
    > out or something I guess) from one browser window, and in another
    > instance of the same web application in another browser window,
    > execute a very quick query, I get the above error message.
    >
    > I have noted the fix at:
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319345
    >
    > But I already have Service Pack 2 installed. Please help!
    >
    > Thanks in Advance
    > James
    bruce barker, Jun 26, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?R3JhbnQ=?=
    Replies:
    2
    Views:
    935
    Joanna
    Sep 13, 2006
  2. Rob Nicholson
    Replies:
    15
    Views:
    20,395
    Rob Nicholson
    Sep 24, 2005
  3. Mythran
    Replies:
    5
    Views:
    4,920
    Mythran
    Oct 5, 2005
  4. DataReader Already Open

    , Nov 24, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    1,812
    Scott M.
    Nov 25, 2006
  5. Bart
    Replies:
    13
    Views:
    799
    =?ISO-8859-1?Q?G=F6ran_Andersson?=
    Mar 28, 2007
Loading...

Share This Page