Configure the Atrex/ElevateDB ODBC Driver

These instructions assume that you have already installed the Atrex ODBC driver and are running Windows 10.   

Press the "Windows" key, or bring up the start menu and search for "ODBC".    If you are running a 32bit operating system, select the ODBC Data Sources option that is displayed.    If you are on a 64bit operating system, you will see two entries, and you must select the ODBC Data Sources option for the bitness level of the application you want to use to connect to Atrex.   If you are attempting to use the ODBC driver with a 32bit application, you will configure your entries via the 32bit ODBC data sources option, and via the 64bit data sources option if you are want to connect with a 64bit application.

1. Start the ODBC Data Source 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.