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:
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319345[/url]

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)

"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:
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319345[/url]
>
> But I already have Service Pack 2 installed. Please help!
>
> Thanks in Advance
> James