Microsoft KB Archive/113845

{|
 * width="100%"|

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

 * }

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 : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420