Description
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.
Applies to
ADO.NET
Syntax
CommandTimeout=value
Default value
None
Usage
The default value for the CommandTimeout parameter is driver-specific.
When you use this parameter with an AdoTransaction object in DataWindow .NET, specify a value for this parameter in the second argument of the AdoTransaction constructor.
Examples
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 page in the Database Profile Setup dialog box.
-
Application
Type the following in code:
SQLCA.DBParm="CommandTimeout=60"
Add the following to the second argument of the AdoTransaction constructor:
CommandTimeout=60
