On UNIX and Linux platforms, you can connect to a Sybase IQ server using ODBC. Use the SQL Anywhere 10 ODBC drivers provided by the SQL Anywhere installer for these platforms:
IBM AIX
Linux x86
Sun Solaris Sparc
Sun Solaris x86 64-bit
HP Itanium 64-bit
For information on how to install SQL Anywhere 10, see “Installing SQL Anywhere 10”.
You must configure the SQL Anywhere 10 ODBC drivers before you use them. See “Configuring ODBC drivers”, for configuration instructions.
In the instructions that follow:
<installation_folder> is the directory where SQL Anywhere is installed.
<lib_version> is the subdirectory containing the SQL Anywhere 10 drivers. The name of this subdirectory can be lib32 or lib64, depending on your configuration.
$USERHOME is the home directory that contains the .odbc.ini file.
The .odbc.ini file contains the ODBC driver configuration information such as the data source name (DSN) definitions. Driver managers such as unixODBC look for the .odbc.ini file specified in the ODBCINI environment variable. For more information on .odbc.ini, see the unixODBC Web site.
In the <installation_folder>, create a symbolic link called libodbc.so to the supplied SQL Anywhere 10 ODBC driver file:
ln -s <installation_folder>/<lib_version>/libdbodbc10.so libodbc.so
In the .odbc.ini file, add an entry similar to:
[My_IQ_Server] Driver=/opt/sybase/<installation_folder>/<lib_version>/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
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_folder>/<bin_version>/ directory, where <bin_version> can be bin32 or bin64, depending on your configuration.
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 ETL Server:
CommLinks=tcpip(DoBroadCast=DIRECT; host=iq_hosting_server;port=2638)
See “Server name caching for faster connections,” in Chapter 3, “Sybase IQ Connections” in the Sybase IQ 12.7 System Administration Guide.
Configuring ODBC drivers 