The following table summarizes timeout connection properties.

Table 1. Timeout Properties
Property Characteristic
LoginTimeout Specifies the amount of time, in seconds, that the driver waits for a connection to be established before timing out the connection request.

If set to 0, the driver does not time out a connection request.

If set to x, the driver waits for the specified number of seconds before returning control to the application and throwing a timeout exception.

The default is 0.
WSRetryCount The number of times the driver retries a timed-out Select request. Insert, Update, and Delete requests are never retried.

If set to 0, the driver does not retry timed-out requests after the initial unsuccessful attempt.

If set to x, the driver retries the timed-out request the specified number of times.

The default is 0.

WSTimeout Specifies the time, in seconds, that the driver waits for a response to a Web service request.

If set to 0, the driver waits indefinitely for a response; there is no timeout.

If set to x, the driver uses the value as the default timeout for any statement created by the connection.

The default is 120.

See also