\r\n
1. \r\n Prerequisites:\r\n
   \r\n
   • You MUST be proficient in using a Unix shell.
   \r\n
   • You MUST be proficient in using a Unix editor such as vi.
   \r\n
   • You MUST be in possession of relevant database connectivity details such as Database name, Username, password, etc.
   \r\n
   • You MUST have installed and available either a full installation of Oracle, Oracle Client, or Oracle Instant Client (release 6.x only).
   \r\n
   \r\n
\r\n
2. \r\n Open the file <OPENLINK_INSTALL>/openlink.sh with a suitable text editor such as vi.\r\n
\r\n
3. \r\n Locate the section that deals with the location of shared libraries pertaining to your system (LD_LIBRARY_PATH, LIBPATH, or SHLIB_PATH) and add to it the location of your Informix lib and lib/esql directories:\r\n

   \r\n      LD_LIBRARY_PATH=\"<OPENLINK_INSTALL>/lib:/oracle/lib:$LD_LIBRARY_PATH\"\r\n    

   \r\n
\r\n
4. \r\n Open the file <OPENLINK_INSTALL>/openlink.ini with a suitable text editor such as vi.\r\n
\r\n
5. \r\n Locate the [Environment Oracle xxx] section that deals with the driver specific Oracle configuration and edit to reflect your Oracle installation:\r\n

   \r\n      [Environment Oracle 10.x]\r\n      ORACLE_HOME        = /oracle/\r\n      ;ORACLE_SID         = ORCL\r\n      ;ORACLE_SERVER      = T\r\n      ;TWO_TASK           = P:\r\n      ;ODBC_CATALOGS      = Y     ; Uncomment after loading odbccat10.sql\r\n      ;MULTIPLEX_LDA      = 5     ; Allow 5 OpenLink clients on a single lda\r\n      ;OPL_USR_TBLS_FIRST = Y     ; Sort SQLTables starting with user tables\r\n      SHOW_REMARKS        = N     ; Retrieve SQLColumns REMARKS field\r\n      CURSOR_SENSITIVITY  = LOW   ; Set to HIGH after loading odbccat10.sql\r\n      ;OCI_PREFETCH_ROWS  = 100   ; Number of rows to prefetch\r\n      ;OCI_PREFETCH_MEMORY = 65535 ; Amount of memory to use for prefetching\r\n      ;NLS_LANG           = AMERICAN_AMERICA.UTF8 ; Unicode connection\r\n    

   \r\n
\r\n
6. \r\n Open the file <OPENLINK_INSTALL>/bin/odbc.ini with a suitable text editor such as vi.\r\n
\r\n
7. \r\n Locate and edit the sample OpenLink Oracle ODBC data source (DSN) created during the installation process and edit as follows:\r\n

   \r\n      [oracle]\r\n      Driver            = <OPENLINK_INSTALL>/lib/ora100_mt_lt.so\r\n      ServerType        = Oracle 10.x\r\n      Options           = <TNSName>\r\n      Username          = <scott>\r\n      Password          = <**********>\r\n      FetchBufferSize   = 99\r\n      ReadOnly          =\r\n      DeferLongFetch    =\r\n      JetFix            = No\r\n      Description       = Sample Oracle 10.x Lite Connection\r\n    

   \r\n
\r\n
8. \r\n Use the iodbctest tool which is packaged with the HTTP-based OpenLink ODBC Administrator as follows:\r\n

   \r\n      # cd <OPENLINK_INSTALL>\r\n      # . ./openLink.sh\r\n      # iodbctest oracle\r\n    

   \r\n

   \r\n iODBC Demonstration program
   \r\n This program shows an interactive SQL processor
   \r\n Driver Manager: 03.52.0507.0105
   \r\n Driver: 06.02.1217 OpenLink Generic ODBC Driver (ora100_mt_lt.so)
   \r\n
   \r\n SQL>\r\n

   \r\n
\r\n
9. \r\n You should now be able to issue SQL statements directly against the target database.\r\n
\r\n

\r\n Additional Information:
\r\n The bitness of the ODBC Driver for MySQL is determined by the bitness of your ODBC client application.
\r\n That is, if your ODBC client application is 32-bit then the Generic ODBC Driver component MUST also be 32-bit.\r\n