TDS buffer length too large

Hot Topic

Selecting the Current Date or yesterday or previous Year, month, quarter or prevous whatever level in the time dimension ?
Starting job on remote server
Displaying huge heirarchial data in reports
manage exception message
Are report parameters cached in the report server?
Possible bug with SqlServer 2005 calling UDT Read method?
SQL Server Express/Visual Studio Express, installation failure
sync_type parameter in subscription
Images not being displayed.
Error when using VariableDispenser in a custom task.

SQL Server

SSIS and SQL Agent is WORTHLESS
Data Source / ODBC error
cursor best practice
Package execution with dtexec and in vs debug differs!
SQL Workbench Object Scripting Broken
Surface Area for Features not connecting
define number of rows returned from query
How to insert a record in the middle of a DB
Calling report from other machine (without domain)
Need help on Matrix Column Grouping

TDS buffer length too large

Getting below sort of error message when running a simple select to a table from Query analyser 2000 to a SQLServer 2000 running with SP4 on different sort of times.

1)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).

Server: Msg 11, Level 16, State 1, Line 0

General network error. Check your network documentation.

Connection Broken

2)

[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

3)

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

[Microsoft][ODBC SQL Server Driver]Invalid cursor state

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

Any one faced this error Any advise please,




Answer this question

TDS buffer length too large

  • xyktiger

  • ShadowOfTheBeast

    The environments like below; Application Server-1: MDAC Version: 2.80.1022.3 ( without SP on 2.8 ) Application Server-2: MDAC Version: 2.71.9030.9 SQL Server MDAC Version 2.81.1117.6 ( with 2.8 SP1 ) Errors came randomly but after restart of the server, system function well. Not sure may be below KB could address http://support.microsoft.com/default.aspx scid=kb;en-us;811007

  • Grattier

    On the Database Server
    Right Click MyNetworkPlaces -> Properties
    Right Click Local Area Connection -> Properties
    Select Internet Protocol(TCP/IP) -> Configure
    Go to Advanced Tab -> Speed & Duplex
    If the value is "auto"
    Set the Value to -> 100mb full

    It resoved my problem, hope it does for you too.

    P.S: I got this problem after I installed SP4.

    Thanks,
    Ganesh



  • TDS buffer length too large
Answer this question