When I try to modify a table that I just created I get the following error message: - Unable to modify table ODBC error:[Mircrosoft][ODBC SQL Server Driver] Invalid cursor state.
SP3 has been applied to SQL Server 2000.
Can anyone help explain what is causing this error? There is sufficient space for the database and transaction log.
If you reuse an hstmt after doing a query that opens a cursor, you need to call SQLCloseCursor(hstmt) before you make your next call.
Hope that helps,
John
|||I guess that you message is from any GUI to manage SQL Server, right ?Jens K. Suessmeyer.
http://www.sqlserver2005.de
sql
No comments:
Post a Comment