1. Prerequisites:
   • You MUST be proficient in using a Unix shell.
   • You MUST be proficient in using a Unix editor such as vi.
   • You MUST be in possession of relevant database connectivity details such as Database name, Username, password, etc.
2. Open the file <OPENLINK_INSTALL>/bin/odbc.ini with a suitable text editor such as vi.
3. Locate and edit the sample OpenLink ODBC To JDBC Bridge data source (DSN) created during the installation process and edit as follows:

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

4. Use the iodbctest tool which is packaged with the HTTP-based OpenLink ODBC Administrator as follows:

         # cd <OPENLINK_INSTALL>
         # . ./openLink.sh
         # iodbctest jdbc
       

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

5. You should now be able to issue SQL statements directly against the target database.

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