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 SQL Server 2019 Big Data Clusters *
Driver version 08.02.0402 (B0766, U0531)
- Certified with SUSE Enterprise Server 15*
Driver version 08.02.0321 (B0603, U0426)
- Certified with Ubuntu Linux 18.04*
Driver version 08.02.0303 (B0572, U0404)
- Certified with Red Hat Enterprise 8.0*
Driver version 08.02.0269 (B0526, U0369)
- Certified with Windows Server 2019*
Driver version 08.02.0211 (B0410, U0280)
- 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 default version of the OpenSSL library has been upgraded to version 1.1.1l, which fixes the following security vulnerabilities:*
- SM2 Decryption Buffer Overflow (CVE-2021-3711)
- Read buffer overruns processing ASN.1 strings (CVE-2021-3712)
Version 1.1.1l also addresses vulnerabilities resolved by earlier versions of the library. For more information on the installed library files, refer to the readme.
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.1.1.html.
- On Windows, the driver has been enhanced to support connecting to servers using aliases
created by the SQL Server Configuration Manager. To support this feature, the
Host Name (HostName) connection option has been refreshed to accept alias names
as valid values. The driver uses the server name and port number provided by
the alias when establishing a connection.*
- The driver has been updated to return the server name to which you are
connected for the value of SQL_SERVER_NAME when executing SQLGetInfo. In
earlier versions of the driver, the value returned for SQL_SERVER_NAME
would be the setting of the Host Name (HostName) connection option. The
driver will now return the server name string that it receives from the server
when connecting to the database as the value for SQLGetInfo(SQL_SERVER_NAME).*
- The driver has been enhanced with the new Keep Connection Active
(KeepConnectionActive) and Socket Idle Time (SocketIdleTimeCheckInterval)
connection options. Together, these options provide you with a method to keep
active idle connections to Azure SQL Database, Azure Synapse Analytics through
Azure SQL Gateway, or to databases that enforce timeouts for inactivity.*
- The curl library files that are installed with the product have been
upgraded to version 7.75.0, which fixes a number of potential security
vulnerabilities. For more information on the vulnerabilities resolved
by this enhancement, refer to: https://curl.haxx.se/docs/vulnerabilities.html.
This upgrade is available starting in build 08.02.0239 of the curl library
files.
- OpenSSL library 1.1.1k has been replaced with version 1.1.1l. In addition to fixing multiple new vulnerabilities, version 1.1.1l also addresses the vulnerabilities resolved by version 1.1.1k:*
- CA certificate check bypass with X509_V_FLAG_X509_STRICT (CVE-2021-3450)
- NULL pointer deref in signature_algorithms processing (CVE-2021-3449)
- Null pointer deref in X509_issuer_and_serial_hash() (CVE-2021-23841)
- Integer overflow in CipherUpdate (CVE-2021-23840)
- The driver has been enhanced to support inserts into SQL Server IDENTITY columns in replication scenarios. Either the Enable Replication User (EnableReplicationUser) connection option or the SQL_COPT_REPLICATION_USER connection attribute (numeric value 1080) can be used to allow inserts into IDENTITY columns. When the replication user feature is set to 1 (Enabled), explicit values can be inserted into IDENTITY columns defined as NOT FOR REPLICATION. If different values are specified for the Enable Replication User option and the SQL_COPT_REPLICATION_USER attribute, driver behavior is determined by the value of the SQL_COPT_REPLICATION_USER attribute.*
- The driver has been enhanced to support access token authentication
programmatically with the use of a pre-connection attribute
SQL_COPT_SS_ACCESS_TOKEN. Refer to the user's guide for more information.*
- The driver has been enhanced to use sp_describe_undeclared_parameters, a SQL
Server system stored procedure, to fetch parameter metadata. With this
enhancement, the driver can return more accurate parameter metadata for both
simple and complex queries. However, it cannot determine if a parameter allows
NULL values; hence, it returns SQL_NULLABLE_UNKNOWN for the nullable fields.
Note that the driver does not call sp_describe_undeclared_parameters to fetch
parameter metadata when Always Encrypted functionality is enabled
(ColumnEncryption=Enabled).*
- OpenSSL library 1.1.1i has been replaced with version 1.1.1l. In addition to fixing multiple new vulnerabilities, version 1.1.1l also addresses the vulnerability resolved by version 1.1.1i: Incorrect behavior of the GENERAL_NAME_cmp function (CVE-2020-1971).*
- OpenSSL library 1.1.1g has been replaced with version 1.1.1l. In addition to fixing multiple new vulnerabilities, version 1.1.1l also addresses the vulnerabilities resolved by version 1.1.1g:*
- Segmentation fault in SSL_check_chain (CVE-2020-1967)
- rsaz_512_sqr overflow bug on x86_64 (CVE-2019-1551)
- OpenSSL library 1.0.2r has been replaced with version 1.0.2u. In addition
to fixing multiple new vulnerabilities, version 1.0.2u also addresses the
vulnerabilities resolved by version 1.0.2r.*
Version 1.0.2u of the OpenSSL library fixes the following security vulnerabilities:
- x64_64 Montgomery squaring procedure used in exponentiation with 512-bit moduli (CVE-2019-1563)
- Padding Oracle in PKCS7_dataDecode and CMS_decrypt_set1_pkey (CVE-2019-1563)
- Compute ECC cofactors if not provided during EC_GROUP construction (CVE-2019-1547)
- Installation paths in diverse Windows builds (CVE-2019-1552)
Note: By default, the driver will attempt to load version 1.1.1 of the library; however, if the library cannot be loaded, the driver will fall back to version 1.0.2.
- The drivers using base version B0649 and later have been enhanced to include timestamp in the internal packet logs by default. If you want to disable the timestamp logging in packet logs, set PacketLoggingOptions=1. The internal packet logging is not enabled by default. To enable it, set EnablePacketLogging=1.*
- The curl library files that are installed with the product have been
upgraded to version 7.66.0, which fixes a number of potential security
vulnerabilities. For more information on the vulnerabilities resolved
by this enhancement, refer to: https://curl.haxx.se/docs/vulnerabilities.html.
This upgrade is available starting in build 08.02.0116 of the curl library
files.
- The driver has been enhanced to support the Always Encrypted feature. Beginning with SQL Server 2016, Azure SQL and SQL Server databases support Always Encrypted, which allows sensitive data to be stored on the server in an encrypted state such that the data can only be decrypted by an authorized application. The following are highlights of this enhancement:
- The driver detects all supported native data types in encrypted columns and transparently encrypts values bound to SQL parameters or decrypts values returned in results and output parameters.
- The driver supports configurable caching of column encryption keys for improved performance.
- The driver supports using Windows Certificate Store and Azure Key Vault as keystore providers.
You can enable support for Always Encrypted using the new Column Encryption, Key Store Principal, Key Store Secret, and Key Cache Time To Live connection options.
- The default OpenSSL library version has been updated to 1.1.1d.*
- The new AllowedOpenSSLVersions option determines which version of the OpenSSL library file the driver uses for data
encryption when multiple versions are installed with the product. For example,
when specifying a value of 1.1.1 (AllowedOpenSSLVersions=1.1.1) the driver uses the 1.1.1 version of the library that is installed with the driver.*
- The default version of the OpenSSL library has been updated to 1.0.2r.*
- The driver has been enhanced to transparently connect to Microsoft Azure Synapse Analytics 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 OpenSSL library has been updated to version 1.0.2n.
Changed Behavior
-
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 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
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