Install the Aster Database ODBC driver as shown below.
- Extract the ODBC package for your operating system into the directory where you want to install the driver.
-
Change to the Aster Database driver directory that was created when you extracted the package:
# cd stage/clients-odbc-<your_client_os>
- On Solaris 64-bit, this directory will contains a compressed file; extract it, too. You will see two drivers. Choose ..\ODBCDriver\libAsterDriver.so
-
Edit your library path environment variable, to add the required libraries to it.
The library path environment variable is:
- On Linux and Solaris: LD_LIBRARY_PATH
- On Mac OS: DYLD_LIBRARY_PATH
An option is to edit an environment settings file (for example, ~/.bashrc file on a typical Linux environment). However, doing so can lead to warning messages from other commands, which have no association with the Aster Database ODBC driver. An alternative option is to create a setup script to set the appropriate environment variable; the script must be “sourced” immediately before using the Aster Database ODBC driver. If a setup script is created to set the appropriate environment variable, consider creating a companion script to unset the environment variable in order to avoid warning messages when no longer using the driver.Use the commands shown below to add the ODBC library, depending on your operating system:
- On Linux or Solaris:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib/stage /clients-odbc-<your_client_os>/Libs
- On Mac OS:
export LD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:/usr/local/lib/stage /clients-odbc-<your_client_os>/Libs
-
Add or edit the ODBCSYSINI environment variable, setting it to the directory where your ODBC connection settings files (odbc.ini and odbcinst.ini) will reside. To follow this example, assume you are working as user “mjones” and will save the configuration files to home directory /home/mjones.
export ODBCSYSINI=/home/mjones
-
Check that the Aster Database ODBC driver library can find all its dependencies. Assuming you have installed in /usr/local/lib, type (on Mac OS, Linux or Solaris):
# cd /usr/local/lib # ldd stage/clients-odbc-<your_platform>/<your_odbcdriver>/ <your_driver_library>
where <your_platform> is one of:
- linux-64
- linux-32
- mac
- mac64
- solaris-sparc64
and where <your_driver_library> is libAsterDriver.so
If a “not found” message does not appear, then all the required libraries have been linked.
-
Choose the next step, depending on your operating system and ODBC driver manager:
- Configure DataDirect Driver Manager on Linux and AIX or Configure DataDirect Driver Manager on Solaris
- Install and Configure unixODBC Driver Manager on Linux, Solaris, AIX, Mac OS
- For Mac OS, go to http://www.iodbc.org to download and configure iODBC driver manager.