TTC_ConnectTimeout

The TTC_ConnectTimeout attribute specifies the maximum number of seconds the client waits for a SQLDriverConnect or SQLDisconnect request. It overrides the value of TTC_Timeout for those requests. Set the TTC_ConnectTimeout when you want connection requests to timeout with a different timeframe than the timeout provided for query requests. For example, you can set a longer timeout for connections if you know that it takes a longer time to connect, but set a shorter timeout for all other queries.

(You can use TTC_SqlTimeoutMS to override TTC_Timeout for all other requests, at a millisecond level.)

A value of 0 means there is no timeout. A negative value defers to the TTC_Timeout setting. As with TTC_Timeout, if the timeout is reached, the connection and the associated socket are closed without a call to SQLDisconnect.

TTC_ConnectTimeout can be set in either the client connection string or the client DSN.

For more details, see Choose SQL and PL/SQL Timeout Values in the Oracle TimesTen In-Memory Database Operations Guide.

Also see TTC_Timeout and TTC_SqlTimeoutMS.

Required Privilege

No privilege is required to change the value of this attribute.

Setting

Set TTC_ConnectTimeout as follows.

Where to set the attribute How the attribute is represented Setting

C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen

TTC_ConnectTimeout

Seconds to wait for a client connect or disconnect request. Default is 20 seconds.

Windows ODBC Data Source Administrator

Not applicable