iAnywhere.com - Key settings for MobiLink and Oracle

There is one iAnywhere Solutions Oracle driver available: the Oracle Wire Protocol driver.

The iAnywhere Solutions Oracle Wire Protocol ODBC driver does not require Oracle client software.

The following are key settings for the Oracle wire protocol driver:

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).
- Host This value provides the location of your Oracle server. On Windows, it is located on the General tab. On UNIX, this attribute is called HostName (HOST).
- Port Identifies the port number of your Oracle listener. On Windows, it is located on the General tab. On UNIX, this attribute is called PortNumber (PORT).
- SID Identifies the Oracle database system ID. On Windows, it is located on the General tab. On UNIX, this attribute is called Sid (SID).
- Default user name This must correspond to a valid user name on the server. On Windows, it is located on the Advanced tab. On UNIX, this attribute is called LoginID (UID).
- Default Buffer Size for Long/LOB Columns(DLDBL) 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).

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