\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
   \r\n
\r\n
2. \r\n Open the file <OPENLINK_INSTALL>/bin/odbc.ini with a suitable text editor such as vi.\r\n
\r\n
3. \r\n Locate and edit the sample OpenLink ODBC To JDBC Bridge data source (DSN) created during the installation process and edit as follows:\r\n

   \r\n      [jdbc]\r\n      Driver            = <OPENLINK_INSTALL>/lib/jdbc90_mt_lt.so\r\n      UserName          = <Username>\r\n      JdbcDriver        = <JDBC Driver Class>\r\n      URLString         = jdbc:openlink://<Connection URL>\r\n    

   \r\n
\r\n
4. \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 jdbc\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 (oplodbc.so)
   \r\n
   \r\n SQL>\r\n

   \r\n
\r\n
5. \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