|
|
|
|
|
|
|
PROPERTY: |
|
|
|
|
commandTimeout |
|
|
|
|
|
|
|
|
|
DESCRIPTION: |
|
|
|
|
Indicates, in seconds, how long to wait while executing a command before terminating the command and issuing and error. |
||
|
|
|
|
|
|
|
PROPERTY OF: |
|
|
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
DEFAULT VALUE: |
|
|
|
|
30 |
|
|
|
|
|
|
|
|
|
DESCRIPTION: |
|
|
|
|
Use the commandTimeout property to allow the cancellation of an executing command, due to delays from network traffic or heavy server use. |
||
|
|
If the interval set in the commandTimeout property elapses before the command completes execution, an error occurs and ADO cancels the command. |
||
|
|
If you set the property to zero, ADO will wait indefinitely until the execution is complete. |
||
|
|
Make sure the provider and data source to which you are writing code support the command time-out functionality. |
||
|
|
|
||
|
|
The data object's commandTimeout property does not inherit the value of the ADODatabase object's commandTimeout value. |
||
|
|
|
||
|
|
On a ADODatabase object, the commandTimeout property remains read/write after the connection with data source is opened. |
||
|
|
|
||
|
|
If a command successfully executed prior to the expiration of the seconds specified in commandTimeout, this property has no effect. |
||
|
|
If execution of a command has not been successfully completed before the time has elapsed, the command is canceled. |
||
|
|
|
||
|
|
The commandTimeout specifies the amount of time, in seconds, before an attempted command times out. |
||
|
|
If a command initiated does not successfully complete prior to expiration of the time specified in commandTimeout, |
||
|
|
the command is canceled and ADO generates an exception. |
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
|
|