Very Computer

by **Jarmo Muukk** » Sat, 23 Oct 1999 04:00:00

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
avoid it?

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.

--
JMu

by **Neil Pik** » Sat, 23 Oct 1999 04:00:00

Jarmo,

Quote:> Subject: "TDS buffer length too large" Error

It's a bug. Try a different net-lib

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (348 entries) see

or www.ntfaq.com/sql.html (+ ntfaq download)
or http://www.swynk.com/faq/sql/sqlserverfaq.asp
or http://www.sql-server.co.uk

by **Jarmo Muukk** » Sat, 23 Oct 1999 04:00:00

We have solved the problem, thanks to Neil Pike who lead me to right
direction.

Default Net Library seems to be Named Pipes, which have bugs. We changed it
to TCP/IP Sockets and now our big (7kB) SELECT statement works properly.
Side effect was small improvement of speed.

--
JMu

>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
>avoid it?

>SQL Server 6.5. Service Packs does not seem to affect behaviour. We use now
>SP5a. Connection to database is through ODBC.