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

Q113845

The information in this article applies to:
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


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