Microsoft Analytics Platform System

Progress DataDirect Connect and Connect64 for ODBC SQL Server Wire Protocol Driver

An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.

Version 8.0.2

Certifications

• Certified with Microsoft Analytics Platform System 10.00
  
• Certified with Microsoft SQL Server 2016, 2017
• Certified with Red Hat Enterprise 7.3
• Certified with Windows Server 2016
• Certified with Debian Linux 7.11, 8.5
• Certified with Ubuntu Linux 14.04, 16.04

Enhancements

• The driver has been enhanced to transparently connect to Microsoft Azure SQL Data Warehouse and Microsoft Analytics Platform System data sources.
• The driver has been enhanced to support connecting to a proxy server through an HTTP connection. HTTP proxy support is configurable with the new Proxy Host, Proxy Mode, Proxy Password, Proxy Port, and Proxy User connection options.
• The new Enable Server Side Cursors connection option allows you to determine which server-side cursors are enabled for the data source.
• The driver is enhanced to support Azure Active Directory (Azure AD) authentication. Azure AD authentication is an alternative to SQL Server Authentication for Azure SQL Database that allows you to centrally manage identities of database users.
• The driver has been enhanced to support Always On Availability Groups. 
   Introduced in SQL Server 2012, Always On Availability Groups is a 
   replica-database environment that provides a high-level of data availability,
   protection, and recovery. To support this enhancement, the following updates
   have been made to the driver:
  • The Host Name option has been updated to support the virtual network name (VNN) of the availability group listener as a valid value. To connect to an Always On Availability group, you must specify the VNN using this option.
  • The new Application Intent option allows you to control whether the driver requests read-only routing, thereby improving efficiency by reducing the workload on read-write nodes. For details, refer to the readme installed with the product.
  • The new MultiSubnetFailover option allows the driver to attempt parallel connections to all the IP addresses associated with an availability group when the primary listener is unavailable. This offers improved response time over traditional failover, which attempts connections to alternate servers one at a time. For details, refer to the readme installed with the product.
• The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
• The driver has been updated with OpenSSL library version 1.0.2n, which addresses the following security vulnerabilities:
  • rsaz_1024_mul_avx2 overflow bug on x86_64 (CVE-2017-3738)
  • Read/write after SSL object in error state (CVE-2017-3737)
  • bn_sqrx8x_internal carry bug on x86_64 (CVE-2017-3736)
  • Malformed X.509 IPAddressFamily could cause OOB read (CVE-2017-3735)

  Version 1.0.2n also addresses the following vulnerabilities resolved by earlier versions of the library.

  For more information on the OpenSSL vulnerabilities resolved by this upgrade, refer to the corresponding OpenSSL announcements at https://www.openssl.org/news/vulnerabilities-1.0.2.html.

Changed Behavior

• The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.

Version 7.1.6

Certifications

• Certified with Microsoft Analytics Platform System 10.00* (driver version 07.16.0369 (B0372, U0245))
• Certified with Red Hat Enterprise 7.3* (driver version 07.16.0361 (B0363, U0242))
• Certified with Windows Server 2016* (driver version 07.16.0352 (B0357, U0237))
• Certified with Debian Linux 7.11*, 8.5* (driver version 07.16.0300 (B0314, U0208))
• Certified with Ubuntu Linux 14.04*, 16.04* (driver version 07.16.0300 (B0314, U0208))
• Certified with Windows 10
• Certified with Red Hat Enterprise 7.1
• Certified with CentOS Linux 7.1
• Certified with Oracle Linux 7.1
• Certified with SUSE Enterprise Server 12

Enhancements

• The driver has been updated with OpenSSL library version 1.0.2n, which addresses the following security vulnerabilities:*
  • rsaz_1024_mul_avx2 overflow bug on x86_64 (CVE-2017-3738)
  • Read/write after SSL object in error state (CVE-2017-3737)
  • bn_sqrx8x_internal carry bug on x86_64 (CVE-2017-3736)
  • Malformed X.509 IPAddressFamily could cause OOB read (CVE-2017-3735)

  Version 1.0.2n also addresses the following vulnerabilities resolved by earlier versions of the library.

  For more information on the OpenSSL vulnerabilities resolved by this upgrade, refer to the corresponding OpenSSL announcements at https://www.openssl.org/news/vulnerabilities-1.0.2.html.
• The driver has been enhanced to support Always On Availability Groups. 
   Introduced in SQL Server 2012, Always On Availability Groups is a 
   replica-database environment that provides a high-level of data availability,
   protection, and recovery. To support this enhancement, the following updates
   have been made to the driver:*
  • The Host Name option has been updated to support the virtual network name (VNN) of the availability group listener as a valid value. To connect to an Always On Availability group, you must specify the VNN using this option.
  • The new Application Intent option allows you to control whether the driver requests read-only routing, thereby improving efficiency by reducing the workload on read-write nodes. For details, refer to the readme installed with the product.
  • The new MultiSubnetFailover option allows the driver to attempt parallel connections to all the IP addresses associated with an availability group when the primary listener is unavailable. This offers improved response time over traditional failover, which attempts connections to alternate servers one at a time. For details, refer to the readme installed with the product.
• The driver has been updated with OpenSSL library version 1.0.2k.*
  Note: OpenSSL library 1.0.2k has been replaced with version 1.0.2n.
• The default OpenSSL library version has been updated to 1.0.2j.*
  Note: OpenSSL library 1.0.2j has been replaced with version 1.0.2n.
• The default OpenSSL library version has been updated to 1.0.2h.*
  Note: OpenSSL library 1.0.2h has been replaced with version 1.0.2n.
• The default OpenSSL library version has been updated to 1.0.2g.*
  Note: OpenSSL library 1.0.2g has been replaced with version 1.0.2n.
• The default OpenSSL library version has been updated to 1.0.2f.
  Note: OpenSSL library 1.0.2f has been replaced with version 1.0.2n.
• The new CryptoLibName and SSLLibName connection options allow you to designate the OpenSSL libraries used when SSL is enabled.

Version 7.1.5

Certifications

• Certified with Red Hat Enterprise 7.0
• Certified with CentOS Linux 7.0
• Certified with Oracle Linux 7.0

Enhancements

• The OpenSSL library was upgraded to version 1.0.0r, which fixes the
  CVE‐2015‐0204 (FREAK) vulnerability. See "RSA silently downgrades
  to EXPORT_RSA [Client] (CVE‐2015‐0204)" at
  https://www.openssl.org/news/secadv_20150108.txt for more
  information.
• The driver has been enhanced to support NTLMv2 authentication, which can be
  enabled using the AuthenticationMethod connection option.
• The new PRNGSeedSource connection option allows you to specifies whether the
  driver uses a file or the RAND_poll function as the seed source for SSL key generation.
• The new PRNGSeedFile connection option allows you to specify the entropy‐source file or device used as a seed for SSL key generation.
• The new Crypto Protocol Version connection option allows you to specify the cryptographic protocols used when SSL is enabled. This option can be used to avoid vulnerabilities associated with SSLv3 and SSLv2, including the POODLE vulnerability.

Version 7.1.4

Certifications

• Certified with Windows 8.1

Enhancements

• The new KeepAlive connection option allows you to use TCP Keep Alive to maintain idle TCP connections.

Version 7.1.3

Certifications

• Certified with CentOS Linux 4.x, 5.x, and 6.x
• Certified with Oracle Linux 4.x, 5.x, and 6.x

Version 7.1.2

Certifications

• Certified with Oracle Solaris 11.1

Version 7.1.1

Certifications

• Certified with Red Hat 6.3
• Certified with Windows 8 and Windows Server 2012