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 http://www.ianywhere.com/developer/technotes/odbc_mobilink.html.