On a server running Microsoft Data Access Components (MDAC) 2.5 and SQL Server 7.0 Service Pack 2 (SP2), I'm receiving the ODBC error message Error 24000: Invalid Cursor State. What does this error message mean?
Invalid Cursor State is a bit of a catchall error message. It appears when a configuration problem exists with the client-side MDAC stack (i.e., when one application requires version X of a .dll file and another version requires version Y, causing the installation for either to delete the other version); when your application makes an ODBC call while results from the previous statement are still processing; or when you try to issue multiple statements across one connection. SQL Server doesn't support using one connection to run three concurrent queries that return result sets.
Learn more at "Automate SQL Server Error Log Checking" and "SQL Server Performance Monitoring and Management Tools."