What does ODBC Error Message Mean?

Microsoft’s SQL Server development team gives three reasons why you might receive this error message.

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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."

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like