Disabling asychronous I/O

  • Hi everyone, we are getting the following error when we run a query:

    [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]Unknown token received from SQL Server

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

    [Microsoft][ODBC SQL Server Driver]TDS buffer length too large

    [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream

    [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]Unknown token received from SQL Server

    While some say that they increased their bandwidth and that fixed the problem, it seems like the problem is that ODBC switches to asynch I/O when the network is slow. And so Microsoft recommends to disable asynch. How do I disable it in sql 2k or ODBC? Thanks in advance for your help!

  • This was removed by the editor as SPAM

  • Hi,

    I don't know if you have already sorted this out, but we are also currently having the same problems, most things I've found on the we point to a network problem. There is an old thread which may help....

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=8585

    I'm about to talk to our network guys again, if you found a solution, please let me know!!

    Thanks

    Dave

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply