Name
Command.CommandTimeout Property — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
Command.CommlandTimeout = Seconds
The CommandTimeout property indicates how long ADO waits, in seconds, before it generates an error when executing an asynchronous command.
Datatype
Long
Description
The CommandTimeout property is read- and write-enabled. With the CommandTimeout property, you can specify how long ADO will wait for a command to execute. The setting for the CommandTimeout property is represented in seconds, and the default value is 30. By setting this property to zero, you are allowing ADO to wait indefinitely for a specified command to execute. If a command does timeout, an error is generated.
The CommandTimeout property of the Command object is unrelated to the CommandTimeout property of the Connection object.
Note
Not all providers support the CommandTimeout property. Check your data provider’s documentation to see if it supports this property. When developing an application with ADO, it might be a good idea to go as far as checking the capabilities of your planned data provider to see whether it matches your needs before you write most of your code -- and it becomes too late.
See Also
Command.Execute Method, Connection.CommandTimeout Property
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access