Logo
Home Cart [Log In] About Us Contact Us

Object Reference

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

See Also:

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;"
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd