May 31, 2006 at 7:10 am
Getting below error message when running a simple select to a table from Query analyser 2000 to a SQLServer 2000 running with SP4.
[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]Protocol error in TDS stream
Any one faced this error? Any advise please,
May 31, 2006 at 8:24 am
Based on this and the problems you are having in your other posts, I'd guess it's a network connectivity issue, and not a true SQL Server problem.
If the network admins claim everything is okay with the network, and if you are not having problems performing other operations on that box, such as saving a file, etc., then I'd check the following.
Attempt to run the same process from a different machine.
If it works fine there, and attempting it again on your machine results in the same error, it's probably localized to your machine. I'd check my network speed/duplex setting, and if it's Auto, try changing it to whatever it needs to be on your network (ask your network admin for this info).
If it doesn't work fine on a different machine, then I'd try to copy a file to and from the SQL Server box, assuming you have privileges to do so.
May 31, 2006 at 6:53 pm
It is does not seem to be localized and network related issue. As I tried on different machinces running the queries. Even the application getting "Time out errors" because of that.
The application connect to SQL Server using OLE DB connection using on .net based application.
June 1, 2006 at 6:34 am
Have you read this http://support.microsoft.com/default.aspx/kb/176256 regarding disabling asynchronous mode?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply