Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > There is already an open DataReader associated with this Connection

Reply
Thread Tools

There is already an open DataReader associated with this Connection

 
 
James Brown
Guest
Posts: n/a
 
      06-26-2003
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...;en-us;Q319345

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

Thanks in Advance
James
 
Reply With Quote
 
 
 
 
bruce barker
Guest
Posts: n/a
 
      06-26-2003
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: 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/default...;en-us;Q319345
>
> But I already have Service Pack 2 installed. Please help!
>
> Thanks in Advance
> James



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
already an open DataReader associated with this Command which must be closed first Bart ASP .Net 13 03-28-2007 10:12 PM
DataReader Already Open rn5a@rediffmail.com ASP .Net 2 11-25-2006 12:46 AM
InvalidOperationException: There is already an open DataReader ass =?Utf-8?B?R3JhbnQ=?= ASP .Net 2 09-13-2006 10:54 AM
There is already an open DataReader associated with this Connection which must be closed first Rob Nicholson ASP .Net 15 09-24-2005 05:18 PM
This key is already associated with an element of this collection dalberon ASP General 2 11-06-2003 05:46 AM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57