skip to main content
Configuring Hybrid Data Pipeline Driver for ODBC : Configuring an ODBC data source on UNIX and Linux systems
  

Try Now

Configuring an ODBC data source on UNIX and Linux systems

The Hybrid Data Pipeline Driver for ODBC is supported on UNIX and Linux systems. Before using the driver on a UNIX or Linux system, an ODBC data source must be configured to work with the driver.
The following procedures require that you have the appropriate permissions to modify your environment and to read, write, and execute various files. You must log in as a user with full r/w/x permissions set recursively across the entire ODBC driver installation directory.
Take the following steps to configure an ODBC data source and test a connection to a Hybrid Data Pipeline data source using the ODBC driver.
1. Check your permissions. You must log in as a user with full r/w/x permissions that apply recursively across the entire ODBC driver installation directory.
2. Set environment variables by running the appropriate product setup script.
Note: Alternatively, you can set environment variables manually. See Setting environment variables manually for details.
a. Determine which shell you are running by executing echo $SHELL from your login shell.
b. Run the appropriate product setup script.
*For Bourne, Korn, and related shells, execute the following command:
. ./odbc.sh
*For C shell and related shells, execute the following command:
source ./odbc.csh
c. Execute env to verify that the following environment variables have been set accordingly.
*Library search path environment variable. The name of the library search path environment variable depends on the platform you are using.
▪ LD_LIBRARY_PATH=/<install_dir>/lib (HP-UX IPF, AIX 5.2 and later, Linux, and Oracle Solaris)
▪ LIBPATH=/<install_dir>/lib (AIX 5.1 and earlier)
▪ SHLIB_PATH=/<install_dir>/lib (HP-UX PA-RISC)
*ODBCINI=/<install_dir>/odbc.ini
*ODBCINST=/<install_dir>/odbcinst.ini
ODBCINST is required for DSN-less connections.
3. Edit the system information file as described in Configuring a data source in the system information file.
4. Test the connection to your data source as described in Example application for UNIX and Linux.
* Setting environment variables manually
* Configuring a data source in the system information file
* DSN-less connections
* Example application for UNIX and Linux