System.InvalidOperationException: There is already an open DataRea

G

Guest

I have a web aspx ap on a web server; however when there is 5-10 ppl use the
app. The database connection tend to fail
The message is System.InvalidOperationException: There is already an open
DataReader associated with this Connection which must be closed first.

Even though I use data adapter. and close the connection every time.
 
M

Marina

It sounds like you are using one connection for the whole site. Don't do
that. Use a new connection each time, and close it when you are done.

If this guess is wrong, that is the best you can get since your post had few
details and no relevant code.
 
E

Ed Hickey [MS]

Hi Marina,

Could you give me ping please? I'd like to talk to you about something, my
e-mail is (remove the two "nospams") (e-mail address removed).

Thanks!

Ed

MVP Lead - VB, VFP, VSTS & VSTO
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

System.invalidOperationException 3
Error running sql command 6
There is already an open DataReader associated with this Connection which must be closed first 2
There is already an open DataReader associated with this Command which must be closed first 13
There is already an open DataReader associated with this Command which must be closed first. 3
Internal connection fatal error and other random db connection err 0
Help .....System.InvalidOperationException: The SqlCommand is currently busy Open, Fetching. 3
There is already an open DataReader associated with this Connection which must be closed first". 1

Top