ElevateDB ODBC Driver Setup Tutorial

NOTICE: if you are having problems with the ODBC driver you should only contact us and not Elevate Software, the makers of this driver. We have an agreement with Elevate to provide this driver to our customers in exchange that we handle all support. Contacting Elevate for support jeopardizes this important business relationship. If you are so unhappy with our ODBC driver support you can purchase a license for this driver from Elevate. Only in this way are you eligible to contact them for support.

After installing the ElevateDB ODBC driver you can then proceed to add or configure data sources (DSNs) as necessary.

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 2000, Windows XP, Vista and Windows 7 you will have to open the Administrative Tools control panel and then the Data Sources (ODBC) icon:

Windows XP Control Panel Administrator tools

In Windows 7 you must choose Systems And Security from the Control Panel.

Windows 7 Control Panel Windows 7 Systems And Security Windows 7 Administrator Tools

If you are using a 64 bit operating system like Windows 7 64, you must run the utility directly by entering this path in the Windows Run command window on the Start menu: c:\windows\syswow64\odbcad32.exe

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

Windows ME ODBC Config

Click the Add button to add a new system DSN. Make sure the ElevateDB ODBC Driver is selected. For Timesheets v5, Employee Project Clock v7 and Project Clock v10 you must choose the Unicode driver. For all other software choose the non-Unicode driver. Then click the Finish button.

Create new data source

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

Configure data source

If you are using a data folder on your network 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 or server folder for the software of ours you are using.

Enter data path

Press Next three times.

Do not use the Remote connection because it does not yet work.

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. The database name is an abbreviation of the program name. So for Project Clock it's PC, for Pro Schedule PS, for Meeting Manager MM, for Timesheets TS and for Employee Project Clock it's EPC. 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

When connecting to this DSN from the other database application you will again need to supply the same Administrator user name and EDBDefault password.