The driver has been enhanced to support Oracle Wallet Password Stores. When this feature is enabled, the driver retrieves database credentials from an Oracle Wallet to be used for authentication to the server. The driver has also been enhanced with the new Credentials Wallet Entry (CredentialsWalletEntry), Credentials Wallet Path (CredentialsWalletPath), Wallet Password (CredentialsWalletPassword) options, which allow you to configure this feature. See Oracle Wallet Password Store for details.
On Windows and UNIX/Linux, the driver has been enhanced to support using connection information stored in an LDAP entry to establish a connection. You can configure the driver to use LDAP with the new LDAP Distinguished Name (LDAPDistinguishedName) option and refreshed Host (HostName) and Port Number (PortNumber) options. For details, see Using LDAP.
The Driver Manager for UNIX/Linux has been enhanced to support setting the Unicode encoding type for applications on a per connection basis. By passing a value for the SQL_ATTR_APP_UNICODE_TYPE attribute using SQLSetConnectAttr, your application can specify the encoding at connection. This allows your application to pass both UTF-8 and UTF-16 encoded strings with a single environment handle. See Driver Manager and Unicode Encoding on UNIX/Linux for details.
On Windows and UNIX/Linux, the driver has been enhanced to support connecting through Oracle Connection Manager. See Oracle Connection Manager for details.
The new AllowedOpenSSLVersions option allows you to determine which version of the OpenSSL library file the driver uses for data encryption. See AllowedOpenSSLVersions or Designating an OpenSSL Library for details.
The driver has been enhanced to support the following new statement attributes that allow you to override connection option settings for an individual statementTroubleshooting:
SQL_ATTR_BULK_LOAD_ENABLED statement attribute overrides the EnableBulkLoad option
SQL_ATTR_IANA_APP_CODE_PAGE statement attribute overrides the IANAAppCodePage option
On Windows and UNIX/Linux, the driver has been enhanced to support connecting to a proxy server through an HTTP connection. HTTP proxy support is configurable with five new connection options. See Proxy Host, Proxy Mode, Proxy Password, Proxy Port, and Proxy User for details.
The driver has been enhanced with the new Impersonate User connection option that allows you to specify the proxy user ID used for impersonation. The user ID specified using this option determines your permissions and identity when executing queries. See Impersonate User for details.
The driver has been enhanced to support using the default Service Name or SID specified in the server-side listener.ora file. See Service Name, SID, and TNSNames File for details.
The driver has been enhanced to support Oracle Database Vault.
The driver has been enhanced to support the Oracle Database Exadata Cloud Service.
Changed Behavior
On the GUI, proxy-related options have been moved from the General tab to the new Proxy tab.
The following Windows platforms have reached the end of their product lifecycle and are no longer supported by the driver:
Windows 8.0 (versions 8.1 and higher are still supported)
Windows Vista (all versions)
Windows XP (all versions)
Windows Server 2003 (all versions)
The setting of the Array Size option can now be overridden by specifying the number of rows to fetch using the SQL_ATTR_ROW_ARRAY_SIZE statement attribute. See Array Size for details.
Changes for 8.0.2 GA
Certifications
Certified with Oracle 12c R2 (12.2)
Certified with Windows Server 2016
Certified with Red Hat Enterprise 7.3
Support for the following platforms is now generally available:
HP-UX IPF (32 and 64-bit)
HP-UX PA-RISC (32-bit)
Oracle Solaris x86 (32- and 64-bit)
Oracle Solaris on SPARC (32- and 64-bit)
Support for the Intel Itanium II (IPF) processor on the following 64-bit Linux platforms is now generally available:
CentOS Linux 4.x, 5.x, 6.x, and 7.x
Oracle Linux 4.x, 5.x, 6.x, and 7.x
Red Hat Enterprise Linux AS, ES, and WS version 4.x, 5.x, 6.x, and 7.x
Support for operating environments and database versions are always being added. For the latest information about supported platforms and databases, refer to the Progress DataDirect database support matrices page at: https://www.progress.com/matrices/datadirect.
Driver Enhancements
Support for Oracle Wallet, including:
Oracle Wallet SSL Authentication
Using Oracle Wallet as a keystore or truststore for SSL data encryption.
The driver has been certified to use Oracle Internet Directory as a means to store authentication information. See Oracle Internet Directory (OID) for details.
The Oracle driver has been enhanced to support the following new data integrity algorithms for Oracle 12c and higher: SHA256, SHA384, SHA512. To use these algorithms, specify their values using the Data Integrity Types connection option and enable data integrity checks with the Data Integrity Level connection option. See Data Integrity Types and Data Integrity Level for details.
The maximum supported length of identifiers has been increased to 128 bytes when connecting to Oracle 12c R2 (12.2) databases. This change has been implemented to reflect the new maximum length supported by the server.
Changed Behavior
The default value for the Data Integrity Types connection option has changed to the following:
Support for the Oracle 12 and 12a authentication protocols, which provide improved security.
Support for returning implicit result sets from stored procedures.
The driver is now compiled using Visual Studio 2015 for improved security.
The new SDU Size connection option allows you to specify the size in bytes of the Session Data Unit (SDU) that the driver requests when connecting to the server. See SDU Size for details.
The new Support Binary XML connection option enables the driver to support XMLType with binary storage on servers running Oracle 12c and higher. See Support Binary XML for details.
The new LOB Prefetch Size connection option allows you to specify the size of prefetch data the driver returns for BLOBs and CLOBs for Oracle database versions 12.1.0.1 and higher. With LOB prefetch enabled, the driver can return LOB meta-data and the beginning of LOB data along with the LOB locator during a fetch operation. This can have significant performance impact, especially for small LOBs which can potentially be entirely prefetched, because the data is available without having to go through the LOB protocol. See LOB Prefetch Size for details.
Changed Behavior
The Enable N-CHAR Support connection option has been deprecated, and the driver behavior has been updated to always provide support for the N-types NCHAR, NVARCHAR2 and NCLOB. For compatibility purposes, the EnableNcharSupport attribute can still be manually specified for this release, but will be deprecated in subsequent versions of the product. See Enable N-CHAR Support and for details.
The Enable Timestamp with Timezone connection option has been deprecated, and the driver behavior has been updated to always expose timestamps with timezones to the application. For compatibility purposes, the EnableTimestampwithTimezone attribute can still be manually specified for this release, but it will be deprecated in subsequent versions of the product. See Enable Timestamp with Timezone for details.
The default value for the Data Integrity Level connection option has been updated to 1 (Accepted). By default, a data integrity check can now be made on data sent between the driver and the database server, if the server request or requires it. This change allows the driver to connect to servers requiring Oracle Advanced Security data integrity checks using the default configuration. See Data Integrity Level for details.
The default value for the Encryption Level connection option has been updated to 1 (Accepted). By default, encryption is now used on data sent between the driver and the database server if the database server requests or requires it. This change allows the driver to connect to servers requiring Oracle Advanced Security encryption using the default configuration. See Encryption Level for details.
Changes for 8.0.0 GA
New Progress DataDirect for Oracle Wire Protocol Driver for Mac OS X
The Oracle Wire Protocol driver is available for Mac OS X platforms, which includes:
Support for the following Mac OS X Platforms:
▪ Mac OS X v10.11.x (El Capitan)
▪ Mac OS X v10.10.x (Yosemite)
▪ Mac OS X v10.9.x (Mavericks)
Support for the following databases:
▪ Oracle 12c R1 (12.1)
▪ Oracle 11g R1, R2 (11.1, 11.2)
▪ Oracle 10g R1, R2 (10.1, 10.2)
▪ Oracle 9i R1, R2 (9.0.1, 9.2)
▪ Oracle8i R3 (8.1.7)
Support for iODBC Driver Manager, version 3.52.7 and higher.
DataDirect Wire Protocol technology for improved response time and throughput.
Support for core SQL-92 grammar.
Supports ODBC Core and Level 1 functions.
Advanced security features, including data encryption, Kerberos authentication, and Oracle Advanced Security.
Release Notes (includes the latest OpenSSL support information)