We have many long and complex SELECT statements. Some of them fails with
error "TDS buffer length too large". What does this error mean and how to
SQL Server 6.5. Service Packs does not seem to affect behaviour. We use now
SP5a. Connection to database is through ODBC.
FYI. I know now KB articles Q137026 "PRB: Error TDS Buffer Length too Large"
and Q121258 "PRB: Connect to SQL on NT 3.5 from WFW 3.11 via Named Pipes".
The fun part is that every computer has Windows NT 4.0. Also our server does
not fail with this error, but our client's server fails.
Network packet size on both servers is 4096 bytes. The only protocol in my
PC is TCP/IP.