FIX: 16-Bit Driver Keyset Cursor Operations with Query Timeout

Article translations Article translations
Article ID: 158665 - View products that this article applies to.
This article was previously published under Q158665
BUG #: 15946 (WINDOWS SQLBUG 2.65.0212)
Expand all | Collapse all


When you use the client-side SPX Net-Library for Windows (Dbmsspx3.dll), the Microsoft SQL Server 16-bit ODBC Driver version 2.65 may perform significantly slower in operations involving both keyset-driven cursors and the setting of a query timeout. Microsoft has observed a difference up to a factor of six when Dbmsspx3.dll is used, versus the other available net- libraries. Note that for this problem to occur, both a query timeout must be set and keyset-driven cursors must be in use with Dbmsspx3.dll.


Microsoft has confirmed this to be a problem in Microsoft client-side SPX Net-Library for Windows (Dbmsspx3.dll) and Open Database Connectivity version 2.65. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.


Article ID: 158665 - Last Review: December 2, 2002 - Revision: 1.0
  • Microsoft Open Database Connectivity 4.21
kbbug kbfix KB158665
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from