Home Cart [Log In] About Us Contact Us

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 Init (
SetConnType As xf_ConnTypeEnum,
SetSQLStatementFormat As xf_SQLStatementFormatEnum,
DbFullPathOrConnectString As String,
Optional UseWorkspace As Workspace,
Optional SetErrLogInfo As String = ""
)

Initialise the DbConnect object for a particular configuration

SetConnType as xf_ConnTypeEnum

The connection type (DAO, ADO, ODBCDirect)

SetSQLStatementFormat as xf_SQLStatementFormatEnum

The statement format (JET, MSSQL)

DbFullPathOrConnectString as String

The database connection string (ADO), or the full database path (DAO). A blank value defaults to CurrentProject.Connection or the current database.

Optional UseWorkspace as Workspace

Open the connection or database in this workspace If omitted, use the first compatible workspace, or create a new one.

Optional SetErrLogInfo as String = ""

Set an identifying string for use in tracking the source of error messages

Call Template:

xf.DbConnect.Init SetConnType, SetSQLStatementFormat, DbFullPathOrConnectString

xf.DbConnect.Init SetConnType, SetSQLStatementFormat, DbFullPathOrConnectString, UseWorkspace, SetErrLogInfo

Example 1:

dim dbc as xf_DbConnect
dbc.Init xf_ConnType_AccessADO, xf_SQLStatementFormat_MSSQL, _
"Provider=SQLOLEDB;Data Source=TESTXP\SQL2008EXPRESS;Initial Catalog=TangGovernance;Integrated Security=SSPI;"