[Microsoft][ODBC SQL Server Driver]Unknown

[Ali Alhussein]

Hi, I am getting this message, anyone knows what could be the reason for this. My connection to the sql server is out too.


[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server

Thanks

Ali

[Igor Shekalev]

From MSDN :

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.

Igor Shekalev, www.sqledit.com

------------
Ali Alhussein at 5/25/01 5:51:33 PM

Hi, I am getting this message, anyone knows what could be the reason for this. My connection to the sql server is out too.


[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server

Thanks

Ali