There is already an open DataReader associated with this Connection

[James Brown]

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]

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)