Error message

[Carolyn]

I'm working on an application that uses a database. I've
recently run into an error and don't know where it comes
from. Maybe someone can help me. When the program gets
to the adapter.fill statement, it stops and shows this
error message:

"An unhandled exception of
type 'System.InvalidOperationException' occurred in
system.data.dll

Additional information: Invalid attempt to NextResult
when reader is closed."

I've run the program successfully a hundred times today
and just now got this error. Can anyone tell me what the
program is looking for or what might be causing the
problem?

Thanks,
Carolyn

 

[hexathioorthooxalate]

Caroline, there isn't really much information to go on here; no database
details, no application details, no code.

So the answer has to vague too. If you haven't changed the application
source or configuration parameters since you ran it a hundred times, and
your database is still up and accessible, then it sounds like some resources
aren't being released or GC'd properly. My advice would be to reboot, and if
it then works, go debugging. Look for things like each time you establish a
database connection, you release it; every database cursor you open, you
close etc.