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 Administrator||dbdsn command line or .odbc.ini file||Description|
|Data source name||-w option in dbdsn; not applicable to .odbc.ini||A name to identify your data source.|
|User ID||UserID||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. If you leave this field blank, you are prompted for the information when you connect.|
|Password||Password||The 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.|
|SID||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 Return Results||ProcResults||You 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 Size||ArraySize||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.|
Open the ODBC Administrator:
The ODBC Data Source Administrator appears.
The Create New Data Source dialog appears.
Choose iAnywhere Solutions 10 - Oracle.
The Driver Setup dialog appears.
Specify the configuration options you need. The fields are explained above.
Click Test Connection, and then click OK.
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.
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.
dbdsn -w MyOracleDSN -or -c Userid=dba;Password=sql;SID=abcd;ArraySize=500;ProcResults=y
See Data Source utility (dbdsn).