iAnywhere Solutions ODBC Drivers
Introduction to ODBC Drivers
Key driver settings for MobiLink
The iAnywhere Solutions ODBC driver for IBM DB2 does not require any DB2 client software. The following are key settings for DB2. Other parameters are available and described elsewhere, but are of less importance.
Basic connection settings Set the following basic connection settings:
DataSourceName (DSN) This value is used to identify the data source.
IpAddress (IP) The IP address of the machine where the catalog tables are stored.
LogonID (UID) This default user ID must correspond to a valid user name on the server.
Tcp Port The port number of the DB2 DRDA listener process on the server host.
Database Name The name of the database to which you want to connect.
WithHold (WH) For use with MobiLink, this attribute must be set to 1 in the ODBC configuration file.
For complete information about settings for DB2, see Connecting to a data source using a connection string.
Users must create the DB2 bind packages on every server to which they intend to connect with the driver. The driver will not work properly with any server that does not have the packages created. The UNIX version of the driver is provided with a program that creates the bind package. It is the equivalent of the Create Package button on the Bind tab of the DB2 driver setup on Windows.
The bind program is shipped with SQL Anywhere Studio, and can be found in the drivers/lib directory under your SQL Anywhere directory. You must export LD_LIBRARY_PATH or LIBPATH before creating bind packages.
For more information, see Configuring data sources.