System.InvalidOperationException: There is already an open DataRea

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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
 
Back
Top