Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » MobiLink - Server Administration » iAnywhere Solutions ODBC Drivers for MobiLink

ODBC drivers supported by MobiLink Next Page

iAnywhere Solutions Oracle driver


The iAnywhere Solutions 10 - Oracle ODBC driver is custom-tailored for use with iAnywhere software. This driver will not work with third-party software.

If you use Oracle with MobiLink or OMNI, you must install an Oracle client on the same machine as this Oracle driver.

The Oracle driver can be configured using the ODBC Administrator, the .odbc.ini file (in Unix), or the dbdsn utility.

The following table provides the configuration options for the Oracle driver.

Windows ODBC Administratordbdsn command line or .odbc.ini fileDescription
Data source name-w option in dbdsn; not applicable to .odbc.iniA name to identify your data source.
User IDUserIDThe default logon ID that the application uses to connect to your Oracle database. A logon ID is required only if security is enabled on your database. If so, contact your system administrator to get your logon ID. If you leave this field blank, you are prompted for the information when you connect.
PasswordPasswordThe password that the application uses to connect to your Oracle database. If you leave this field blank, you are prompted for the information when you connect.
SIDSIDThe Oracle System Identifier that refers to the instance of Oracle running on the server. This item is required when connecting to servers that support more than one instance of an Oracle database. The SID is stored in network/admin/tnsnames.ora under your Oracle installation directory.
Procedures Return ResultsProcResultsYou should select this field if your stored procedures can return results. The default is that procedures do not return results (not selected). If your download_cursor or download_delete_cursor scripts are stored procedure invocations, set this to yes.
Array SizeArraySizeThe size, in bytes, of the byte array used to pre-fetch rows, on a per-statement basis. The default is 60000. Increasing this value can significantly improve fetch performance (such as during MobiLink server downloads) at the cost of extra memory allocation.
Windows configuration
To create a DSN for the Oracle driver in Windows
  1. Open the ODBC Administrator:

    The ODBC Data Source Administrator appears.

  2. Click Add.

    The Create New Data Source dialog appears.

  3. Choose iAnywhere Solutions 10 - Oracle.

    The Driver Setup dialog appears.

  4. Specify the configuration options you need. The fields are explained above.

  5. Click Test Connection, and then click OK.

Unix configuration

On Unix, if you are setting up the driver in an ODBC system information file (typically called .odbc.ini), the section for this driver should appear as follows (with appropriate values entered for each field):

[sample_dsn_using_the_ias_odbc_driver_for_oracle]
Driver=full-path/libdboraodbc10_r.so
UserID=user-id
Password=password
SID=oracle-system-identifier
ProcResults=[yes|no]
ArraySize=bytes

For an explanation of each field, see above.

DBDSN configuration

To create an Oracle DSN with the dbdsn utility, use the following syntax:

dbdsn -w data-source-name -or -c configuration-options

The configuration-options are described above.

For example:

dbdsn -w MyOracleDSN -or -c Userid=dba;Password=sql;SID=abcd;ArraySize=500;ProcResults=y

See Data Source utility (dbdsn).

See also