Configuring SQL Anywhere ODBC Drivers for UNIX and Linux

Set up SQL Anywhere ODBC drivers for Sybase IQ 15.3.

The conventions used are:

<installation_directory> is where SQL Anywhere is installed.
<lib_version> is the subdirectory containing the SQL Anywhere 11 drivers. Depending on your configuration, the name of the subdirectory is lib32 or lib64.
$USERHOME is the home directory that contains the .odbc.ini file.

In the <installation_directory>, create a symbolic link called libodbc.so to the supplied SQL Anywhere 11 ODBC driver file:

ln -s <installation_directory>/<lib_version>/libdbodbc11.so libodbc.so

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

[My_IQ_Server]
Driver=/opt/sybase/<installation_directory>/<lib_version>
/libdbodbc11.so
uid=dba
pwd=SQL
EngineName=My_IQ_Server_iqdemo
CommLinks=tcpip(host=iq_hosting_server;port=2638)
AutoStop=no
DatabaseName=iqdemo

Add the environment variable ODBCINI=$USERHOME/.odbc.ini to your server.
To set the necessary environment variables, run the sa_config.sh or sa_config.csh file in the <installation_directory>/<bin_version>/ directory, where <bin_version> can be bin32 or bin64, depending on your configuration.

Note: If you have multiple Sybase IQ servers with the same server name, database name, and port number, use server name caching to connect to the target Sybase IQ server. Add the DoBroadcast=DIRECT communication parameter to the CommLinks connection parameter, in the .odbc.ini file, in your IQ InfoPrimer Server:

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

See Sybase IQ 15.2 System Administration Guide: Volume 1 > Connection and Communication Parameters > Network Communications parameters.