FIX: OS/2 DB-Library Will Return a Timeout Only Once

 Last reviewed: April 29, 1997
Article ID: Q113845

The information in this article applies to:
  • Microsoft SQL Server Programmer's Toolkit, version 4.21
BUG# 6474 (4.21)

SYMPTOMS

If a DB-Library (DB-Lib) timeout condition occurs, the error handler will receive error 10024: 

   SQLETIME: SQL Server connection timed out
as expected. However, if the error handler then returns INT_CONTINUE, it will receive error 10005: 

   SQLEDDNE: DBPROCESS is dead or not enabled
instead of 10024 from DB-Library the next time a timeout occurs.

CAUSE

DB-Library is not correctly handling the second timeout once the application error handler has returned INT_CONTINUE.

WORKAROUND

Flag the timeout condition in the error handler through the use of a global variable or the dbsetuserdata and dbgetuserdata functions. Return INT_CANCEL from the error handler. Cancel the query request and resubmit.

STATUS

Microsoft has confirmed this to be a problem in DB-Library 4.21. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: Windows NT sql6
Keywords : kbbug4.21 kbfix6.00.sp1 kbprg SSrvDB_Lib SSrvProg
Version : 4.21 | 4.21 | 4.21 6.0
Platform : MS-DOS OS/2 WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.