SQL Server Performance Forum – Threads Archive

TDS Buffer / Unknown token

Hello,
I am getting the following messages when I turn on Statistics IO [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server I have read about every article I can via Google, but all the solutions are for older machines. I haven’t found any relevant to SQL 2000 on Windows 2000/3. I found one piece that said to turn of asyncronis in the ODBC driver, but didn’t explain how to do that. Can someone please shed a little like on the message or how to turn off Asyn in the ODBC driver? Thanks
L

What version of ODBC are you using, and what SQL Server service pack?
Have a look in ODBC Administrator, on the about Tab Also see similar thread
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11475#52870

This happened to us sometime ago due to the mismatch of MDAC version between the servers.
The message also indicates that the process for the connection issues inside SQL Server, because of an access violation, stack overflow. In this case, you need to find a stack dump in the SQL Server errorlog. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

]]>