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

         [sqlserver]
         Driver            = <OPENLINK_INSTALL>/lib/sql_mt_lu.so
         ServerType        = SQLServer 2000
         Options           = -H sqlserver.hostname -P 1433
         Database          = database
         UserName          = sa
         Password          = **********
         FetchBufferSize   = 99
         ReadOnly          = no
         DeferLongFetch    = no
         JetFix            = no
         Description       =
       

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

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

   iODBC Demonstration program
   This program shows an interactive SQL processor
   Driver Manager: 03.52.0507.0105
   Driver: 06.02.1217 OpenLink Generic ODBC Driver (sql_mt_lt.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.