There is already an open DataReader associated with this Connection

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/defaul...b;en-us;Q319345

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

Thanks in Advance
Jamesbug 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" <jbrown_gtfc@.hotmail.com> wrote in message
news:7a947814.0306260125.6425510a@.posting.google.c om...
> 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/defaul...b;en-us;Q319345
> But I already have Service Pack 2 installed. Please help!
> Thanks in Advance
> James