Name
Connection.CommandTimeout Property — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
connection.CommandTimeout = timeout
The CommandTimeout property indicates how long ADO waits before it generates an error when executing a particular command.
Datatype
Long
Description
The CommandTimeout property is read- and write-enabled. By using 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 time out, an error will be generated.
The CommandTimeout property of the Command object is unrelated to the CommandTimeout property of the Connection object.
The Connection object’s CommandTimeout is read- and write-enabled even when the Connection object is open.
Note
Not all providers support the 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