Invalid Cursor State (CRecordset Requery)

[Ryan Hunter]

MS SQL 7.0

My application requery's a crecordset class every 30
seconds checking for new data. works great for a while
(maybe 20 hours, 5 days, a week) and then it fails. (catch
an exception in Requery() function of recordset)

error: invalid cursor state

Any idea what is causing this?

[Jivko Dobrev [MS]]

Hello Ryan,

Interesting problem. Many different factors could cause this behavior.
Here're some ideas:

1) Verify the SQL Server's ERRORLOG. Check if any severe errors are logged
during the same time when the error is raised. For instance - access
violations or similar
2) Check the MDAC on the client and the server machine. Use the Component
Checker tool from http://www.microsoft.com/data/ and if corrupted, download
the appropriate version, stop SQL (if on the server) and the data-aware
applications (if on the client) and update/fix the MDAC
3) This behavior could occur if you share sessions across threads

Hope that this information will be useful for you.
Have a wonderful day!
Jivko Dobrev

This posting is provided "AS IS" with no warranties, and confers no rights.