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:
In Windows 7 you must choose Systems And Security from the Control Panel.
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 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.
Enter a descriptive name for the data source. Click Next.
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.Press Next three times.
Enter Administrator for the User Name and EDBDefault for the password: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.
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.
When connecting to this DSN from the other database application you will again need to supply the same Administrator user name and EDBDefault password.