• Topic
  • Discussion
  • UdaWikiWeb.NoOPENLINKODBCINI(Last) -- Owiki? , 2016-08-19 15:00:36 Edit owiki 2016-08-19 15:00:36

    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

    • Names of all .taz files
    • Output of


      set uname -a

    • the complete openlink.sh and openlink.csh files

    Referenced by...