\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 MySQL ODBC data source (DSN) created during the installation process and edit as follows:\r\n

   \r\n      [mysql]\r\n      Driver            = <OPENLINK_INSTALL>/lib/mys5_mt_lt.so\r\n      ServerType        = MySQL 5.x\r\n      Options           = -H mysql5.hostname\r\n      Database          = database\r\n      UserName          = mysql\r\n      Password          = **********\r\n      FetchBufferSize   = 99\r\n      ReadOnly          = no\r\n      DeferLongFetch    = no\r\n      JetFix            = no\r\n      Description       = Sample MySQL 5.x Lite Connection\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 mysql\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