FIX: Err Msg "Unknown Token Received from SQL Server"
Article ID: 151693
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q151693
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: kbbug kbfix kbnetwork KB151693