Installing and configuring SQL Anywhere 10 ODBC drivers

On UNIX and Linux platforms, connect to a Sybase IQ server using ODBC. Use the SQL Anywhere 10 ODBC drivers provided by the Sybase IQ ETL Server installer for these platforms:

• IBM AIX

• Linux x86

• Sun Solaris Sparc

The Sybase IQ client installer provides the ODBC drivers for Microsoft Windows platforms.

You must configure the SQL Anywhere 10 ODBC drivers before you use them. You can configure the drivers with or without an ODBC driver manager. If you configure the drivers without a driver manager, no other ODBC drivers are available.

In the instructions that follow, etlserver is the directory where ETL Server is installed, asa10 is the subdirectory containing the SQL Anywhere 10 drivers, and %USERHOME% is the home directory that contains the .odbc.ini file.

1. In the ODBC driver manager, select the SQL Anywhere 10 driver in etlserver/asa10.

2. In the .odbc.ini file, add an entry similar to:

   [My_IQ_Server]
   Driver=/opt/sybase/iqetlserver/asa10/lib64/libdbodbc10.so
   uid=dba
   pwd=SQL
   EngineName=My_IQ_Server_asiqdemo
   CommLinks=tcpip(host=iq_hosting_server;port=2638)
   AutoStop=no
   DatabaseName=asiqdemo
   AutoPreCommit=yes
   

3. Add the environment variable ODBCINI=%USERHOME%/.odbc.ini to your server.

1. In etlserver/asa10, create a symbolic link called libodbc.so to the supplied SQL Anywhere 10 ODBC driver file:

   ln -s etlserver/asa10/lib64/libdbodbc10.so libodbc.so

2. In the .odbc.ini file, add an entry similar to:

   [My_IQ_Server]
   Driver=/opt/sybase/iqetlserver/asa10/lib64/libdbodbc10.so
   uid=dba
   pwd=SQL
   EngineName=My_IQ_Server_asiqdemo
   CommLinks=tcpip(host=iq_hosting_server;port=2638)
   AutoStop=no
   DatabaseName=asiqdemo
   AutoPreCommit=yes
   

3. Add the environment variable ODBCINI=%USERHOME%/.odbc.ini to your server.

CommLinks=tcpip(DoBroadCast=DIRECT;
host=iq_hosting_server;port=2638)