iAnywhere Solutions ODBC Drivers
iAnywhere Solutions ODBC Driver for Oracle
On Windows, data sources are configured and modified through the ODBC Administrator.
In the UNIX environment, there is no ODBC Administrator. To configure a data source in the UNIX environment, you must edit the system information file using the attributes in Values for IANAAppCodePage Connection String Attribute. You must also edit this file to perform a translation.
For more information, see The system information file (.odbc.ini).
To configure an Oracle data source
Start the ODBC Administrator to display a list of data sources.
If you are configuring an existing data source, select the data source name and click Configure to display iAnywhere Solutions 9 - Oracle Wire Protocol Driver Setup.
If you are configuring a new data source, click Add to display a list of installed drivers. Select the Oracle Wire Protocol driver of your choice and click Finish to display the iAnywhere Solutions 9 - Oracle Wire Protocol Driver Setup.
NOTE: The General tab displays only fields that are required for creating a data source. The fields on all other tabs are optional, unless noted otherwise.
On the General tab, provide the following information and then click Apply.
Data Source Name Type a string that identifies this Oracle Wire Protocol data source configuration in the system information. Examples include "Accounting" or "Oracle-Serv1."
Description Type an optional long description of a data source name. For example, "My Accounting Database" or "Oracle on Server number 1."
Host Type either the name or the IP address of the server to which you want to connect. For example, if your network supports named servers, you can specify a server name such as Oracleserver. Or, you can specify an IP address such as 199.226.224.34.
Port number Type the port number of your Oracle listener. Check with your database administrator for the correct number.
SID Type the Oracle System Identifier that refers to the instance of Oracle running on the server.
Optionally, click the Advanced tab to specify data source settings. On this tab, provide any of the following optional information; then, click Apply.
Default User Name Type the default user name used to connect to your Oracle database. A default user name is required only if security is enabled on your database. Your ODBC application may override this value or you may override this value in the logon dialog box or connection string.
Array Size Type the number of bytes the driver uses for fetching multiple rows. Values can be an integer from 1 up to 4 GB; the default is 60000. Larger values increase throughput by reducing the number of times the driver fetches data across the network. Smaller values increase response time, as there is less of a delay waiting for the server to transmit data.
Lock Timeout Type 0, -1, or any integer value greater than 0. The value 0 specifies that Oracle does not wait for a lock to be freed before raising an error when processing a Select...For Update statement. The value -1 waits forever. When connected to an Oracle9i server, you can specify the number of seconds to wait by setting this option to an integer greater than 0. If you are connected to an Oracle8i or lower server, any value greater than 0 is equivalent to the value -1.
Default Buffer Size for Long/LOB Columns (in Kb) Type an integer value that specifies the maximum length of data fetched from Long/LOB columns. The value must be in multiples of 1024 (for example, 1024, 2048). The default is 1024 KB. You will need to increase this value if the total size of any long data exceeds 1 MB.
Local Timezone Offset This feature is not supported. Do not enter anything.
Enable Timestamp with Timezone This feature is not supported. Do not select it. By default, the check box is not selected.
Catalog Options Select this check box if you want the result column REMARKS for the catalog functions SQLTables and SQLColumns, and the result column COLUMN_DEF for the catalog function SQLColumns to have meaning for Oracle. Selecting this box reduces the performance of your queries. By default, the check box is not selected, which returns SQL_NULL_DATA for the result columns COLUMN_DEF and REMARKS.
Enable SQLDescribeParam Select this check box to enable the SQLDescribeParam function, which results in all parameters being described with a data type of SQL_VARCHAR. This option should be selected when using Microsoft Remote Data Objects (RDO) to access data. By default, the check box is not selected.
Application Using Threads This check box must be selected. Selecting this option ensures that the driver works with multi-threaded applications. By default, the check box is selected.
Procedure Returns Results Select this check box to enable the driver to return result sets from stored procedures/functions. If this check box is selected and you execute a stored procedure that does not return result sets, you will incur a small performance penalty. By default, the check box is not selected.
Enable Static Cursors for Long Data: Select this check box to enable the driver to support long columns when using a static cursor. Selecting this check box causes a performance penalty at the time of execution when reading long data. By default, the check box is not selected.
NOTE: You must select this check box if you want to persist a result set that contains LONG data into an XML data file.
Use Current Schema for SQLProcedures Select this check box to specify only the current user when executing SQLProcedures. When this check box is selected (the default), the call for SQLProcedures is optimized, but only procedures owned by the user are returned.
Catalog Functions Include Synonyms By default, the check box is selected.
Describe at Prepare Select this check box to enable the driver to describe the SQL statement at prepare time. By default, the check box is not selected.
Translate Click Translate to display the Select Translator dialog box, which lists the translators specified in the ODBC Translators section of the system information. DataDirect provides a translator named "OEM TO ANSI" that translates your data from the IBM PC character set to the ANSI character set. Select a translator; then, click OK to close this dialog box and perform the translation.
At any point during the configuration process, you can click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box. A logon dialog box is displayed. Note that the information you enter in the logon dialog box during a test connect is not saved. If the driver can connect, it releases the connection and displays a "connection established" message. Click OK. If the driver cannot connect because of an improper environment or incorrect connection value, it will display an appropriate error message. Click OK.