Specifies the number of seconds the interface should wait for a command to execute.
When to specify CommandTimeout
You must specify a value for CommandTimeout before connecting
to the database.
ADO.NET
CommandTimeout = value
Parameter |
Description |
|---|---|
value |
The number of seconds the interface waits for a command to execute. |
None
The default value for the CommandTimeout parameter is driver-specific.
To set the CommandTimeout value to wait 60 seconds for a command to execute:
Database
profile Type 60 in the Command
Timeout box on the System tab in the Database Profile Setup dialog
box.
Application Type the following in code:
SQLCA.DBParm = "CommandTimeout=60"
