FIX: Err Msg "Unknown Token Received from SQL Server"

ID: Q151693

The information in this article applies to:

Microsoft SQL Server version 6.5

SYMPTOMS

When you set the statement options to use a server-side cursor and prepare a select statement on a SQL Server system table, the first execution of the select creates the cursor successfully. After you close this cursor, if you execute the prepared statement again, the following error message appears:

unknown token received from SQL Server.

WORKAROUND

Use a forward-only cursor instead of a static, keyset, or dynamic cursor on the system tables. Note that the problem does not occur if a server-side cursor is created on a user-defined table or view.

If a forward-only cursor is unacceptable, prepare the select statement again on the system table and execute it to create a server-side cursor. Note that the first execution works fine and applications typically do not need to create a cursor on a system table repeatedly.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.50.0201. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: ODBC MFC VB RDO


Keywords          : kbnetwork SSrvGen kbbug6.50 kbfix6.50.sp1 
Version           : 6.5.0201
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 27, 1999