KB485845:How to Configure an ODBC Driver for Sybase IQ on Linux

To Install the Sybase IQ ODBC Driver on Your Environment:

1. Download the Sybase IQ installer from SAP.
2. Run the following command to start the installation:
   

   
   tar -zxvf Linux64-iq1610_eval.tgz
   cd Linux64-iq1610sp05_eval
   ./setup.bin
   

   
   
3. Choose Custom.
4. Deselect all options except the SAP IQ Client.

Note: Only installing an SAP IQ ODBC driver does not establish an ODBC connection. However, the SAP IQ Client will have an ODBC driver included.
To Define the Location of Your Environment:

1. In a Linux console window, navigate to the directory you specified as your home directory during installation and browse the

   env

   folder.
2. Add write privileges to the

   ODBC.sh

   file by entering the following command:

    chmod u+w OBDC.sh

3. In the

   ODBC.sh

   file, edit the 'Directory Path value' in the following definition with your directory path:

   IQDIR16='Directory Path'.

4. Save the

   ODBC.sh

   file.
5. Remove write privileges from the file by entering the following command:

   chmd a-w OBD.sh

6. Restart your I-Server.

To Configure Your Linux Environment without DSN:

1. In a Linux Console window, navigate to the directory you specified as your home directory during installation.
2. Use the following template to configure the

   odbcinst.ini

   file:
   

   
   [Sybase IQ]
   Driver=/lib/libdbodbc12_r.so (if 15.4) or libdbodbc16_r.so (if 16.0)
   Description=IQ ODBC Driver
   APILevel=0
   ConnectFunctions=YYY
   DriverODBCVer=3.52
   FileUsage=0
   Setup=/lib/libdbodbc12_r.so (if 15.4) or libdbodbc16_r.so (if 16.0)
   SQLLevel=0
   DriverUnicodeType=1
   

   
   
3. Replace the Driver and Setup values above with those that match the location of your ODBC driver.

To Configure Your Linux Environment with DSN:

1. In a Linux Console window, navigate to the directory you specified as your home directory during installation.
2. Open the odbc.ini.example file and navigate to the section that begins "[SAP SYBASEIQ16]".
3. Copy the section into the

   odbc.ini

   file.
4. Edit the EngineName, DatabaseName, and CommLinks DSN parameters.
5. Edit the value of the driver to reflect the ODBC driver directory location.
6. Save the

   odbc.ini

   file.

For more information on the DSN parameters, see your database vendor product documentation.