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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » ODBC Configuration Dialog Help

ODBC Configuration dialog: DBMLSync tab Next Page

Configuration for iAnywhere Driver for Oracle dialog

This dialog lets you set configuration information for the ODBC driver for Oracle, which is called iAnywhere Solutions 10 - Oracle.

The Configuration for iAnywhere driver for Oracle dialog has the following components:

Data source name    Enter a name to identify your data source.

User ID    The 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.

Password    The password that the application uses to connect to your Oracle database.

SID    The 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 Returns Results     You should select this field if your 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 Size    The 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.

Test Connection    Tests whether the information provided results in a proper connection. In order for the test to work, a user ID and password must be specified.

For updated information about the Oracle driver, see [external link]