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.