■
■ The driver supports failover and its related connection options. Failover connection options are located on the Failover tab of the driver Setup dialog box. See “Using Failover” for a general description of failover and its implementation.Oracle provides a client information feature that allows an administrator to define different work load classifications and store client information associated with a connection. These workload classifications can be assigned different priorities and resource allocations. To enable applications to leverage these work load classifications fully, the Connect for ODBC Oracle Wire Protocol driver provides connection options for setting the session properties that are used in identifying a work load. These options are located on the Client Monitoring tab of the driver Setup dialog box. See “Using Client Information” for a general description of client information and its implementation.The driver supports authentication and encryption. Security connection options are located on the Security tab of the driver Setup dialog box. See “Using Security” for a general description of security and its implementation. The following security information is specific to the Oracle Wire Protocol Driver.If you are using Kerberos, verify that your environment meets the requirements listed in Table 8-3 before you configure the driver for Kerberos authentication.
Database server The database server must be administered by the same domain controller that administers the client and must be running one of the following databases:
■ Oracle 11g (R1 and R2)
■ Oracle 10g (R1 and R2)
■ Oracle 9i (R2) The Kerberos server is the machine where the user IDs for authentication are administered. The Kerberos server is also the location of the Kerberos KDC.
■ Windows Active Directory on one of the following operating systems: Windows Server 2003 or Windows 2000 Server Service Pack 3 or higher To enable support for SSL connections to Oracle, the Oracle database must be configured with the Oracle Advanced Security bundle. This is an option available from Oracle as an add-on to Oracle Enterprise Edition Servers.The following link explains the supported configurations and how to configure Oracle Enterprise servers for SSL:The driver supports connection pooling and its related connection options. Connection pooling connection options are located on the Pooling tab of the driver Setup dialog box. See “Using DataDirect Connection Pooling” for a general description of connection pooling and its implementation.The driver supports DataDirect bulk load and its related connection options. Bulk load connection options are located on the Bulk tab of the driver Setup dialog box. See “Using DataDirect Bulk Load” for a general description of DataDirect bulk load and its implementation.The Oracle Wire Protocol driver uses array binding instead of DataDirect Bulk Load when the Oracle server version is older than Oracle 9i R1 (9.0.1)
■ Once a bulk operation is started, any non-bulk operation is disallowed until the transaction is committed.
■ The Oracle Wire Protocol driver currently does not support the use of LONG and LONG RAW data types with array binding.
■ Because of Oracle limitations, issuing a SELECT statement to determine a row count may return different results before and after a bulk load operation.
■ Oracle does not support literal values in a bulk load operation. You must use parameter markers for all columns being loaded.