No OpenLink ODBC.INI file found

The "No OpenLink ODBC.INI file found" error message suggests that the $ODBCINI environment variable has not been set. If you receive this error, take the following action:

  1. cd into the root directory of your OpenLink client components installation. For example: 


    $ cd /opt/openlink

  2. Execute the command which corresponds to your Unix shell --
    shell command
    sh, bash, zsh . ./openlink.sh
    ksh source ./openlink.sh
    csh, tcsh source ./openlink.csh

  3. Confirm that $ODBCINI, $ODBCINSTINI, and $OPENLINKINI are set. For example: 


    % set | grep INI
ODBCINI=/opt/openlink/bin/odbc.ini
ODBCINSTINI=/opt/openlink/bin/odbcinst.ini
OPENLINKINI=/opt/openlink/bin/openlink.ini

    • If the variables now appear to be set, proceed to the next numbered step.
    • If the variables do not appear to be set, review the content of the openlink.sh or openlink.csh script. Take note of the environment variable settings therein. Then, try to manually set them on the command line. For example (your output will differ!): 


      % cd /opt/openlink
% cat openlink.sh
ODBCINI=/opt/openlink/bin/odbc.ini
ODBCINSTINI=/opt/openlink/bin/odbcinst.ini
OPENLINKINI=/opt/openlink/bin/openlink.ini
LD_LIBRARY_PATH=/opt/openlink/lib
OPL_LICENSE_DIR=/opt/openlink/bin

export ODBCINI ODBCINSTINI OPENLINKINI LD_LIBRARY_PATH OPL_LICENSE_DIR

% export UDBCINI=/opt/openlink/bin/udbc.ini
% export ODBCINI=/opt/openlink/bin/odbc.ini
% export ODBCINSTINI=/opt/openlink/bin/odbcinst.ini
% export LD_LIBRARY_PATH=/opt/openlink/lib
% export OPL_LICENSE_DIR=/opt/openlink/bin

  4. Stop and restart the HTTP-based OpenLink? ODBC Administrator, so it picks up the new environment variable settings -- 


    % /opt/openlink/bin/iodbc-admin-httpd.sh stop
% /opt/openlink/bin/iodbc-admin-httpd.sh start

  5. Reattempt your browser-based configuration.


Evidence