ADODB Object
 
Syntax
 
long = connectionobject.CommandTimeout
connectionobject.CommandTimeout = long
 
Description
Sets the number of seconds to wait while attempting an Execute method call before terminating the attempt and generating an error message.
The CommandTimeout property defines how many seconds to wait before cancelling an Execute method call and generating an error. The default is thirty seconds. If you set CommandTimeout equal to zero seconds, the program will wait indefinitely or until the Execute is completed.
 
The Command object has a similar property, but the two properties do not inherit from each other.
See Also
Example
 
objConnection.CommandTimeout = 0