Housekeeping functions

Public Property Get ConnType() As xf_ConnTypeEnum

Return the configured connection type

Public Property Get DaoDatabase() As DAO.Database

Return the DAO database object, if applicable.


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.


Public Sub SetCommandTimeout(TimeoutSecs As Long)

Set the query timeout for ADO sources. This is not applicable to DAO/ODBC. Note that this applies to the return time of the specific query, not the connection in general.


Public Sub SetPassThroughConnectionString(PassThroughConnectionString As String)

Set the default connection string for DAO pass-through queries. This can be overridden in the ExecutePassthroughQuery method, but is useful when multiple pass-through queries are to be executed on the same database.


Public Property Get SQLStatementFormat() As xf_SQLStatementFormatEnum

Return the configured SQL statement format

Public Property Get WorkspaceName() As String

Return the name of the Workspace used by the connection