These conventions are used in this section:
<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.
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_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_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_directory>/<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.
