DBOpen

Windows Instream and HIPAA Validator Desktop

Opens an ODBC connection to a particular database.

Format of Parameters

DBRef  ResultVar  Connection

Where:

DBRef Identifier you are giving to this ODBC connection. It is used in subsequent ODBC business rules to tell Validator which database to use. DBRef must be alphanumeric with no spaces.
ResultVar

Variable that is to be used to contain the results of the DBOpen command. Result will be:

0 =     Database opened successfully

-1 =     Bad parameter or argument

-2 =     Could not allocate ODBC environment handle

-3 =     Could not allocate ODBC connection handle

-4 =     Could not connect to database

-5 =     Could not allocate ODBC statement handle
Connection The connection string used to establish the connection to the database. The connection string can be supplied in the $Dir.ini file (see page Setting up your ODBC Connection String) rather than here. If you use local in the connection string, be sure that it will be correct on all machines where this guideline will be used.

Example 1: SQL database.

Example 2: Access database.

Example 3: Named Data Source (via Control Panel>Administrative Tools>Data Sources (ODBC)).

or