Description
Specifies the number of seconds the interface should wait for a connection to the data provider to complete.
When to specify TimeOut
You must specify a value for TimeOut before connecting to the database.
Applies to
ADO.NET
OLE DB
SNC SQL Native Client for Microsoft SQL Server
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
Syntax
TimeOut=value
Default value
None
Usage
The default value for the TimeOut parameter is driver-specific.
Examples
To set the TimeOut value to wait 10 seconds for a connection to complete:
-
Database profile
Type 10 in the Timeout box on the System page in the Database Profile Setup dialog box.
-
Application
Type the following in code:
SQLCA.DBParm="TimeOut=10"
