8 The Oracle Wire Protocol Driver : Advanced Features

Advanced Features
The driver supports the following advanced features:
Failover
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.
Client Information
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.
Security
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.
Authentication
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.
Encryption
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:
http://download.oracle.com/docs/cd/B28359_01/network.111/b28530/asossl.htm#i1013323
Connection Pooling
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.
DataDirect Bulk Load
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)
Limitations
Because of Oracle limitations, issuing a SELECT statement to determine a row count may return different results before and after a bulk load operation.