CdbWorkspace::OpenConnection Method

Opens a Connection object on an ODBC data source (ODBCDirect workspaces only).

Syntax

CdbConnectionOpenConnection(LPCTSTR pstrName,

LONG lOption=-1L,

BOOL bReadOnly=FALSE,

LPCTSTR pstrConnect=NULL);

Parameters

Type Example Description
LPCTSTR pstrName A pointer to a string that contains the name of a registered ODBC data source (DSN). If it doesn't refer to a valid ODBC data source name, an error occurs.
LONG IOption Optional. A Long value that specifies how the ODBC driver manager should prompt the user for connection information such as DSN, user name, and password. Possible values are described in Remarks.
BOOL bReadOnly Optional. A Boolean.

TRUEOpens a Connection object for read-only access.

FALSE(Default) Opens a Connection object for read/write access.

LPCTSTR pstrConnect Optional. A pointer to a string that contains the ODBC connect string. See the Connect property for the specific elements and syntax of this string. A prepended "ODBC;" is required. If Connect is omitted (default), the UID and/or PWD will be taken from the UserName and Password properties of the Workspace.

Remarks

The following are valid Options values.

Constant Description
dbDriverNoPrompt The ODBC driver manager uses the connection string provided in Name and Connect. If sufficient information is not provided, a trappable error is returned.
dbDriverPrompt The driver manager displays the ODBC Data Sources dialog box. The connection string used to establish the connection is constructed from the DSN selected and completed by the user via the dialog boxes, or, if no DSN is chosen, the default DSN is used.
dbDriverComplete If the Connect argument includes the DSN keyword, the driver manager uses the string as provided in Connect. Otherwise it behaves as it does when dbDriverPrompt is specified.
dbDriverCompleteRequired Behaves like dbDriverComplete except the driver disables the prompts for any information not required to complete the connection.
dbRunAsync Execute the method asynchronously. This constant may be used with any of the other Options constants.

The OpenConnection method is similar but not equivalent to OpenDatabase. The main difference is that OpenConnection is available only in an ODBCDirect workspace.

Usage

#include <afxole.h>
#include <dbdao.h>
CdbDBEngine      dben(..., dbUseODBC);
CdbWorkspace      wksp;
CdbConnection   conn;
CdbRecordset      rstX;
wksp = dben.Workspaces[0L];
conn = wksp.OpenConnection(_T("ODBC;..."), 
                           (dbDriverNoPrompt|dbRunAsync),
                           FALSE, T("DATABASE=SomeDB..."));
rstX = conn.OpenRecordset(...);