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.

End of Article


You must log on before posting a comment.

If you don't have a username & password, please register now.

Reader Comments

this article is really helpful to know why invalid cursor state error occurs.but it would be more helpful if this article states how to get rid of this error.

Anonymous User- April 05, 2005

Article Rating 3 out of 5