iAnywhere Solutions ODBC Drivers
  Introduction to ODBC Drivers
    Key driver settings for MobiLink

Key settings for MobiLink and Adaptive Server Enterprise

The ODBC driver for Adaptive Server Enterprise does not require any Adaptive Server Enterprise client software. The following are key settings for Adaptive Server Enterprise. Other parameters are available and described elsewhere, but are less important.

• Basic connection settings    Set the following basic connection settings:

  • Data source name    This value is used to identify the data source. On Windows, it is located on the General tab. On UNIX, this attribute is called DataSourceName (DSN).

  • Network library name    For TCP/IP networks, set this to Winsock. On Windows, it is located on the General tab. On UNIX, this attribute is called NetworkLibraryName (NLM).

  • Network address and port of the server (General tab)    These should be separated by commas; for example, server-machine,1500. On Windows, it is located on the General tab. On UNIX, this attribute is called NetworkAddress (NA).

  • Default Logon ID used for the connection    This is case sensitive and must correspond to a valid logon ID on the server. On Windows, it is located on the Connection tab. On UNIX, this attribute is called LogonID (UID).

• DefaultLongDataBuffLen    

  This parameter specifies (in Kb) the size of the largest LONG BINARY or LONG VARCHAR column value being synchronized. The default setting is 1024, which is equivalent to 1 Mb. If you are synchronizing long columns with entries larger than this, set the value higher.

  This parameter appears on the Advanced tab of the Windows driver ODBC setup dialog. On UNIX, this attribute is called DefaultLongDataBuffLen (DLDBL).

• SelectMethod    

  This parameter can be 0 or 1. When you use 0 (the default), database cursors are used. When set to 1, SELECT statements are run directly, without cursors.

  This parameter appears on the Performance tab of the Windows driver ODBC setup dialog. On UNIX, this attribute is called SelectMethod (SM).

• OptimizePrepare    This parameter can be 0, 1, 2, or 3. For use with MobiLink, set it to 2.

  This parameter appears on the Performance tab of the Windows driver ODBC setup dialog. On UNIX, this attribute is called OptimizePrepare (OP).

For complete information about settings for the Adaptive Server Enterprise driver, see Connecting to a data source using a connection string.