The iAnywhere Solutions 11 - Oracle ODBC driver is custom-tailored for use with Sybase IQ or iAnywhere. This driver does not work with third-party software.
If you use Oracle with OMNI, you must install an Oracle client on the same computer as this Oracle driver.
Use the ODBC Administrator, the .odbc.ini file (in UNIX), or the iqdsn utility to configure the Oracle driver.
Table 3-1provides the configuration options for the Oracle driver.
Windows ODBC Administrator |
Configuration for iqdsn command or .odbc.ini file |
Description |
|---|---|---|
Data Source Name |
For iqdsn, use the -w option. |
A name to identify your data source. |
User ID |
In iqdsn, set the UserID option in the connection string. |
The default login ID that the application uses to connect to your Oracle database. If you leave this field blank, you must supply the information when you connect. |
Password |
In iqdsn, set this option in the connection string. |
The password that the application uses to connect to your Oracle database. If you leave this field blank, you must supply the information when you connect. |
SID |
SID |
The TNS Service Name that is stored in network/admin/tnsnames.ora under your Oracle installation directory. |
Enable Microsoft Distributed Transactions |
For iqdsn, use the enableMSDIC option in the connection string. Not supported for .odbc.ini. |
Select this option to enlist your transactions in the Microsoft Distributed Transaction Coordinator. When selected, the Oracle ODBC driver requires an Oracle binary file, oramts.dll for Oracle 9i clients or oramts10.dll for Oracle 10g clients. |
Encrypt Password |
For iqdsn, use the -pe option.Not supported for .odbc.ini. |
Select this option to store the password in encrypted form in the data source. |
Procedures Return Results |
In iqdsn, set the ProcResults option in the connection string. |
Select this option 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 |
In iqdsn, set the ArraySize option in the connection string. |
The size, in bytes, of the byte array used to prefetch rows, on a per-statement basis. The default is 60000. Increasing this value can significantly improve fetch performance at the cost of extra memory allocation. |
