CommandTimeout database parameter
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.
Controls
-
ADO.NET
Syntax
|
1 |
CommandTimeout=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
The number of seconds the interface waits |
Default
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
profileType
60in the Command
Timeout box on the System page in the Database Profile Setup dialog
box. -
Application
Type the following in code:
1SQLCA.DbParameter="CommandTimeout=60"Add the following to the second argument of the AdoTransaction constructor:
1CommandTimeout=60