Support and Certifications

Visit the following web pages for the latest support and certification information.

Changes since 8.0.2 GA

  • Driver Enhancements
    • The default version of the OpenSSL library has been upgraded to 3.5.6. As part of this upgrade, earlier version of the OpenSSL 3.0 library continues to be supported to provide the best protection for your data. The upgrade is available in the following OpenSSL library files:
      • Windows: ivopenssl.dll and ddopenssl.dll
      • Unix: ivopenssl.so and ddopenssl.so
    • The driver has been enhanced to support the SCRAM-SHA-256 password hashing mechanism for user ID/password authentication. The SCRAM-SHA-256 mechanism is supported with Greenplum server v6.21 and higher.
    • The driver is now compiled with a Visual Studio 2022 compiler for the Windows platforms. As a result, you must have Microsoft Visual C/C++ runtime version 14.40.33810 or higher on your machine to run the driver.

Changes for 8.0.2 GA

  • Driver Enhancements
    • The driver has been enhanced to support the TLSv1.3 cryptographic protocol for TLS/SSL encryption. See Crypto Protocol Version for details.
    • 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 to support the Windows certificate store for TLS/SSL server authentication. See TLS/SSL server authentication for details.
    • The driver has been enhanced to support TLS/SSL server authentication for the applications deployed in a server-less environment. The driver stores the TLS/SSL certificates in memory and lets applications use TLS/SSL server authentication without storing the truststore file on the disk. To use this enhancement, specify the content of the certificate in the updated Trust Store (Truststore) connection option or the new SQL_COPT_INMEMORY_TRUSTSTORECERT pre-connection attribute. See Using SQL_COPT_INMEMORY_TRUSTSTORECERT for details.
    • The default version of the OpenSSL library has been upgraded to 3.0. As part of this upgrade, earlier versions of the OpenSSL library are no longer supported to provide the best protection for your data. The upgrade is available in the following OpenSSL library files: xxopenssl30.dll (for Windows) and xxopenssl30.so [.sl] (for UNIX/Linux).

      The OpenSSL 3.0 library uses a set of shared libraries called providers to implement different types of cryptographic algorithms. The driver supports the following OpenSSL 3.0 providers: FIPS and default. See TLS/SSL server authentication and TLS/SSL client authentication for details.

    • 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.

      The valid values for the SQL_ATTR_APP_UNICODE_TYPE attribute are SQL_DD_CP_UTF8 and SQL_DD_CP_UTF16. The default value is SQL_DD_CP_UTF8.

    • The driver has been enhanced with the new Batch Mechanism (BatchMechanism) connection option, which specifies the preferred mechanism for executing batch insert operations. By setting Batch Mechanism to 2 (MultiRowInsert) or 3 (Copy), the driver can achieve substantial performance gains when performing batch inserts. The default setting is BatchMechanism=3 (Copy).

    • The driver has been enhanced to support the following data types: Citext, Float, and Tinyint. See Data Types for details.
    • A Power BI connector is now included with the product package. You can use this connector to access your Greenplum data with Power BI. Refer to the user's guide for details.
    • A Password Encryption Tool, called ddencpwd, is now included with the product package. It encrypts passwords for secure handling in connection strings and odbc.ini files. At connection, the driver decrypts these passwords and passes them to the data source as required. See Password Encryption Tool (UNIX/Linux only) for details.
  • Changed Behavior
    • The HP-UX PA-RISC platform is no longer supported.
    • The default value for the Batch Mechanism (BatchMechanism) connection option has been changed to 3 (Copy).
    • The TLSv1.1 and TLSv1.0 cryptographic protocols are now disabled by default and have been removed as selectable options for the Crypto Protocol Version (CryptoProtocolVersion) option on the Setup dialog. These protocols are no longer considered secure and, therefore, are no longer recommended for use. However, the driver still supports them for legacy servers that do not support the TLSv1.3 or TLS1.2 protocols. See Crypto Protocol Version for details.
    • The default values for the Unbounded Numeric Precision (UnboundedNumericPrecision) and Unbounded Numeric Scale (UnboundedNumericScale) options have been changed to -1.
    • The Allowed OpenSSL Versions (AllowedOpenSSLVersions) connection option has been deprecated.
    • The product no longer includes version 1.1.1 of the OpenSSL library. The library will reach the end of its product life cycle in September 2023 and will not receive any security updates after that. Note that continuing to use the library after September 2023 can potentially expose you to security vulnerabilities.
      Note: As a result of this change, when installing a new version of the product, the installer program will automatically remove version 1.1.1 of the library from the install directory, which will impact all the DataDirect ODBC drivers installed on a machine. Therefore, if you are using multiple drivers, upgrade all your drivers to the latest version.
    • The product no longer includes version 1.0.2 of the OpenSSL library. The library has reached the end of its product life cycle and is not receiving security updates anymore. Note that continuing to use the library could potentially expose you to security vulnerabilities.
      Note: As a result of this change, when installing a new version of the driver, the installer program will automatically remove version 1.0.2 of the library from the install directory.
    • The crypto protocol versions prior to TLSv1 are no longer supported.
    • 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)