Microsoft KB Archive/112189

From BetaArchive Wiki

INF: Setting Packet Size Using VBSQL

Q112189



The information in this article applies to:


  • Microsoft SQL Server Programmer's Toolkit, version 4.2





SUMMARY

DB-Library (DB-Lib) version 4.20.50 introduced two new functions (DBSETLPACKET and dbgetpacket) that allowed a DB-Lib application to attempt to increase the packet size used to communicate with a remote server. By increasing packet size, it is sometimes possible to improve throughput of large BCPs and text/image data transfers. Version 4.21 of VBSQL.VBX introduces two new functions that can be used to set the packet size in Visual Basic-SQL applications.



MORE INFORMATION

Detailed information on these new functions is contained in the 4.21 PTK release notes

Additional query words: dblib vb bcp performance increase

Keywords : kbprogramming
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420


Last Reviewed: March 19, 1999
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.