Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC connection loss : time out too long, catching it not fast enough

Status
Not open for further replies.

PROPAR

Programmer
Oct 25, 2001
51
FR
I'using SQL Server 6.5 from a VisualC++ application.

The connection sequence looks like :

SQLSetEnvAttr(...,..., &hENV...
SQLAllocHandle(..., ..., &hDBC...
SQLSetConnectAttr(hDBC,...
SQLConnect(hDBC,...

While the connection is functionnal I do

SQLExecute(...

When there is a connection loss SQLExecute fails.

The time between SQLExecute and consecutive failure is too long and must be shorten.

So my question is :
How do I shorten the time taken by (SQLExecute, ODBC driver, SQL Server...) to catch the connection loss ?

Is it possible to configure the (ENV, DBC, RDO, server...) to shorten the time out ?

(this is not the query time-out, which is positionned to 1800 sec. to allow large query results, but would be a "watchdog" or failure time out for ODBC connection).

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top