Configure the Atrex/ElevateDB ODBC Driver

These instructions assume that you have already installed the Atrex ODBC driver and are running Windows 7.   If you are not running Windows 7, the instructions on how to configure the ODBC driver is the same, but the ODBC Administrator may not be in the same location in the Windows control panel.

If you are running a 32bit operating system, you can use the standard ODBC Administrator available from the Windows control panel via the instructions below.  If attempting to configure the ODBC source on a 64bit operating system, you must run the 32bit ODBC administrator.  To do this, click the Start button, and enter "%systemdrive%\Windows\SysWoW64\Odbcad32.exe" in the command line and click OK.

1. Start the ODBC Administrator.  You can locate this via "Start - Settings - Control Panel - System and Security - Administrative Tools - Data Sources (ODBC)".  Double click on this entry to open up the Administrator.

2. Click on the System DSN tab.  

3. Click the Add button.

4. Select the ElevateDB 2 ODBC Driver (Unicode) driver and click Finish.

5. Enter a name for the for the DSN.  It is through this name that you will be able to identify the DSN from other applications and as such the name should give some indication of what it will be pointing to.  If you only have 1 Atrex database, we recommend that you simply name the DSN "Atrex"  (without the quotes).

6. Set the connection type. If you are set to use direct access to the Atrex data files across a network, leave this as a local connection.  If you are set up to run Atrex using client/server check the Remote option. Click Next.

7. If you are prompted for the Character Set to use, select the "Unicode" option.   Click Next.

For Local Connections:

a. Click the Select button and locate the Atrex Central folder.  If you are not sure where your Atrex central folder is, you can find this by starting Atrex and selecting "Options - System Information" from the main Atrex menu.  The central path will be listed on the default tab of that window.

b. Click Next until you reach the User Name and Password window.  Use the following values:
   User Name: Administrator
   Password: EDBDefault

c. Select the database name that you want to connect to.  If you are using named locations within Atrex, each entry will be displayed in the drop down list box for you to select from.  Choose the location name that you want to connect to.  If you are not using named locations, select the "DirectData" entry.  Click Next after selecting a database.

d. Select a folder for the temporary tables.  When selecting this folder, remember that the Windows user ID used to access the ODBC driver will most likely not be the same as the user ID that you are using to create the DNS entry.  As such, please select a location on the hard drive that is accessible by ALL users.

For Remote Connections: (Leave any unspecified values at their default value)

a. Enter the Host Name OR the IP address of the server that has the Atrex Database Server running on it. Click Next. 

b. Click the check box to enable pinging.  If you are connecting to a server that is not located physically within your local area network set the compression to optimal, otherwise leave it to none. 

c. Enter the User Name and Password that you are using within Atrex to connect to your server.  While you can use the administrator name and password, it is not recommended.

d. Click on the Drop Down listbox to select the Atrex database that you want to use.

7. Leave the Lock Retry Count at 15 and the Lock Retry Wait Time at 100 msecs.  Click Next.

8. Leave the Force OS Buffer Flushes and Use Strict Change Detection options unchecked.  Click Next.

At this point, the driver setup window will be closed and the DSN entry has been completed.  You should now be able to access the DSN from your ODBC enabled application.

Add Feedback