skip to main content
Getting Started : Configuring an ODBC Data Source on UNIX and Linux Systems
 

Try DataDirect Cloud Now

Configuring an ODBC Data Source on UNIX and Linux Systems

The following information enables you to configure a data source and test the connection.
Note: In the following examples, xx in a driver filename represents the driver version. The prefix for the 32-bit driver file name is iv. The prefix for the 64-bit driver file name is dd.
To configure the environment:
1. Check your permissions: You must log in as a user with full r/w/x permissions that will apply recursively across the entire product installation directory.
2. From your login shell, determine which shell you are running by executing:
echo $SHELL 
3. Run one of the following product setup scripts from the installation directory to set variables: odbc.sh or odbc.csh. For Korn, Bourne, and equivalent shells, execute odbc.sh. For a C shell, execute odbc.csh. After running the setup script, execute:
env 
to verify that the installation_directory/lib directory has been added to your shared library path.
4. Set the ODBCINI environment variable. The variable must point to the path from the root directory to the system information file where your data source resides. The system information file can have any name, but the product is installed with a default file called odbc.ini in the product installation directory. For example, if you use an installation directory of /opt/odbc and the default system information file, from the Korn or Borne shell, you would enter:
ODBCINI=/opt/odbc/odbc.ini; export ODBCINI 
From the C shell, you would enter:
setenv ODBCINI /opt/odbc/odbc.ini 
5. Set the DD_INSTALLDIR environment variable. The variable should point to the path from the root directory to the product installation directory. The driver uses this variable to locate support files in the installation directory.
6. Edit the system information file as described in Configuring a Data Source in the System Information File.
* Configuring a Data Source in the System Information File