We have a vb6 application that among other things queries sql server 2005 db
over lan. On the client side, where do I control the size of network buffer?

Thanks in advance

What are you trying to accomplish by setting the size of the network buffer?
What problem are you having? Are you concerned with performance, security,
locks or what?

--
__________________________________________________ ________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
__________________________________________________ __________________________________________



"RG" <RG (AT) discussions (DOT) microsoft.com> wrote

RG (RG (AT) discussions (DOT) microsoft.com) writes:
In the connection string with the PacketSize keyword. The default is
4096, and as Bill says there is probably little reason to meddle with it.
But you can set it to 256 to see the effect - things will be slower!


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx