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.
    1. Determine which shell you are running by executing echo $SHELL from your login shell.
    2. 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
    3. Execute env to verify that the following environment variables have been set accordingly.
      • LD_LIBRARY_PATH=/<install_dir>/lib
      • 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 Configuration through the system information file.
  4. Test the connection to your data source as described in The Example application.