Determines whether long-running queries in threaded applications can be cancelled if the application issues a SQLCancel.
Valid Values
0 | x
where:
x
is the number of seconds the driver waits before checking for SQLCancel calls.
Behavior
If set to 0 (None), the driver does not allow long-running queries in threaded applications to be canceled, even if the application issues a SQLCancel.
If set to x (seconds), for every pending query, the driver checks for SQLCancel calls at the specified interval. If the driver determines that a SQLCancel has been issued, the driver cancels the query.
Notes
This connection option can affect performance.
Example
If you specify 5, for every pending query, the driver checks every five seconds to see whether the application has issued a SQLCancel call. If it detects a SQLCancel call, the driver cancels the query.
This connection option can affect performance.