SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Protocol error in TDS stream


Protocol error in TDS stream

Author
Message
melthedba
melthedba
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1306 Visits: 161
Hello,

Recently, I began receiving error messages while connecting to a server via Query Analyzer and running sp_helptext, for instance. I received the below error on numerous occasions:
[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
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server

Does anyone have a reason for this error and a fix? I've been searching the web and already updated MDAC to 2.7 but still the error persists. Other than MDAC, I haven't seen any other resolution suggested for the problem.

Thank you so much,
Melanie



Antares686
Antares686
SSC Guru
SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)

Group: Moderators
Points: 91704 Visits: 803
Try reinstalling your NIC drivers. If the buffer is too large the driver may be screwing up packets. Might be server side or client side. ALso, as you stated you did MDAC 2.7 make sure both client and server.



melthedba
melthedba
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1306 Visits: 161
Hello Antares686,

Thank you very much for your recommendation. I'll try this and let you know how it goes.

Melanie



melthedba
melthedba
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1306 Visits: 161
Hello,

Well, our network guy decided to defrag all of our systems and so far we haven't experienced any TDS errors again... and hope we never do. We did not update MDAC nor touch the NIC cards.

Thanks,
Melanie



Jonr
Jonr
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1776 Visits: 65

Just as a follow up to this, we saw the same problem on a brand new, 4 processor HP server. Doing very simple remote select queries on it from another box took 1+ minute to return 1000 rows, over an hour to handle a 78,000 row table. Sometimes it would bomb out with:

[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
(repeated 3x)

Running either query locally returned the data immediately, so we ruled out CPU, memory and disk I/O as a cause. This focused our attention on the network connection.

Eventually our resident network expert took a look at the pair of network cards and noticed a very large number of transmit errors in the properties tab, over 300,000,000. He tracked it down to a switch which had recently replaced an old hub, and the network card settings on the server hadn't been adjusted accordingly. They were set to half duplex, so he changed them to full duplex and everything went much faster - the 1000 rows query took just 2 seconds to return the full data set rather than over a minute.




Jon
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search