ElevateDB ODBC Driver Setup Tutorial

After installing the ElevateDB ODBC driver certain aspects of the driver be configured.  Once you have configured the driver, you can then proceed to add or configure data sources (DSNs) as necessary.

Configuring the driver

Complete the following steps to properly configure the ElevateDB ODBC Driver.  These steps are illustrated using Windows XP, but are very similar for most other versions of Windows.

1. Run the ODBC Driver Configuration utility provided with the ElevateDB ODBC Driver:

a. Click on the installed ElevateDB DAC product from the Start Menu.

Configure ODBC driver

b. Click on the ElevateDB ODBC Driver Configuration link in the sub-menu for the ElevateDB DAC product:

Configure ODBC driver

2. Make sure that the configuration file folder is set to the program's data folder. The folder will default to the Elevate DB DAC program folder but you should not use that. Instead use the data folder for the software of ours you are using.

Set configuration file path

3. Update any other driver configuration settings as necessary.  Each configuration item contains a description that explains the purpose of the item.  If you do not understand a configuration item, leave it as the default value.  Apart from the configuration file folder, most applications will use the default values for all other configuration items.

4. Click on the OK button to close the ElevateDB ODBC Driver Configuration utility and update the driver configuration.

After you have successfully updated the driver configuration, you can then proceed to configure a data source for use with the driver by using the steps outlined in the Data Source Configuration Tutorial topic in this manual.

Creating a data source (DSN)

Before using the ODBC driver you must create a new ODBC data source. New ODBC data sources are created in the ODBC Data Sources control panel. To open the ODBC Data Sources control panel choose Start | Settings | Control Panel from the start menu. In Windows 98 and Windows ME you will see something like this:

Double click the ODBC Data Sources control panel to open it. In Windows 2000, Windows XP and Vista you will have to open the Administrative Tools control panel and then the Data Sources (ODBC) icon:
Control panel

Administrator tools 

From the ODBC Data Source Administrator click on the System DSN tab.


Click the Add button to add a new system DSN. Make sure the ElevateDB 1 ODBC Driver is selected. Then click the Finish button.
Create new data source

Enter a descriptive name for the data source. Click Next.
Configure data source

Keep the connection at Local and press Next. Make sure that the configuration file folder is set to the program's data folder. The folder will default to the Elevate DB DAC program folder but you should not use that. Instead use the data folder for the software of ours you are using. 

Enter data path

Press Next three times. Enter Administrator for the User Name and EDBDefault for the password:

Data source login

Press Next and at the next screen choose the database to connect to. In this case we will choose PC. You will possibly see something else depending on which software you are trying to connect to. You should never choose the Configuration database as this will connect you to system tables only.

Select database

Press Next three times until you get to the Force buffer flush setting screen then click the Finish button. You will have successfully created a system DSN that can be used from most common database application to access CyberMatrix Data.
System DSN added