Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
System Library

xf_DbConnectDatabase Access Wrapper

Public Sub SetADOConnectionTimeout (
TimeoutSecs As Integer
)

Set the connection timeout for ADO sources. This must be done BEFORE opening the ADO connection, which occurs in the Init method of DbConnect.
Note that this is not applicable to DAO/ODBC. The only way to change the ODBC connection timeout from the default of 60 seconds is via a registry setting.

TimeoutSecs as Integer

The timeout in seconds

Call Template:

xf.DbConnect.SetADOConnectionTimeout TimeoutSecs

Example 1:

dbc.SetADOConnectionTimeout 5  ' five seconds
dbc.Init xf_ConnType_AccessADO, xf_SQLStatementFormat_MSSQL, _
"Provider=SQLOLEDB;Data Source=TESTXP\SQL2008EXPRESS;Initial Catalog=TangGovernance;Integrated Security=SSPI;"

Object Reference

Public Sub SetADOConnectionTimeout (TimeoutSecs As Integer)

TimeoutSecs as Integer

Call Template:

See Also:

Example 1:

Public Sub SetADOConnectionTimeout (
TimeoutSecs As Integer
)