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

ID: Q113845

The information in this article applies to:

Microsoft SQL Server Programmer's Toolkit, version 4.2

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          : kbprg SSrvDB_Lib SSrvProg kbbug4.21 kbfix6.00.sp1 
Version           : 4.21 | 4.21 | 4.21  6.0
Platform          : MS-DOS OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 19, 1999