ODBC Driver 17.5 for SQL Server Released

[David-Engel]

Version 17.5 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.5.1 brings a few new features and a handful of fixes to the driver.

Features

• New SQL_COPT_SS_SPID connection attribute provides SPID without a round-trip to the server
• Support for indicating EULA acceptance via debconf on Debian and Ubuntu
• Support for Alpine Linux (3.10 and 3.11)
• Support for Oracle Linux 8
• Support for Ubuntu 19.10
• Support for macOS Catalina (10.15)

Fixes

• Fixed AKV CMK metadata hash computation on Linux/Mac
• Fixed error when loading OpenSSL 1.0.0
• Fixed conversion issues when using ISO-8859-1 and ISO-8859-2 codepages
• Fixed internal library name on Mac to include version number
• Fixed setting of null indicator when separate length and indicator bindings are used

Note: Linux packages for 17.5 were briefly unavailable due an issue in the mssql-tools package but are now available (4 Feb) with an updated mssql-tools package.

Next steps

For Windows installations, you can directly download the Microsoft ODBC Driver 17 for SQL Server.

Linux and macOS packages are also available. For installation details see the online instructions.

Roadmap

We are committed to improving quality and bringing more feature support for connecting to SQL Server Azure SQL Database Azure SQL DW, and Azure SQL Managed Instance through regular driver releases. We invite you to explore the latest the Microsoft Data Platform has to offer via a trial of Microsoft Azure SQL Database or by evaluating Microsoft SQL Server.

David Engel

[BobPaul]

As of March 6, the direct download link in this article (https://go.microsoft.com/fwlink/?linkid=867666) is broken, and it appears v17.5.2.1 has been released.  Are there any release notes as to what's changed?  Also, are there any ways to download older versions (v17.2, v17.3) for compatibility testing?  Thanks.

[David-Engel]

@BobPaulYou probably hit the download site as 17.5.2.1 was syncing out to all the servers. It was just released. It may take an hour or so to sync to all caches. Docs, including release notes, should appear on the docs site sometime this afternoon.

As for download links to older versions, look for those on the docs release notes page in a week or so (I'm working on it).

Regards,

David

[David-Engel]

@BobPaul Changes are up. The docs download page has been revamped and you can download previous versions from the docs release notes page now.

Regards,

David

[PrabuM]

Is there any link which explains the support agreement with Microsoft for using the ODBC driver on a linux server (RHEL 7 e.g. ) to connect to a SQL server 2019 hosted on a Windows ? I could not find any . Thanks in advance  

[David-Engel]

Hi @PrabuM,

Please see the System Requirements for Linux/macOS: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/system-requirements?view=sql-server-ver1...

The SQL version compatibility is the same for the driver on Linux as it is on Windows. As far as the operating system hosting the target SQL instance, there are no restrictions about an ODBC client on Linux connecting to a SQL Server on Windows or vice versa.

Regards,

David

[PrabuM]

Hi @David-Engel 

Thank you for the link. This helps for our scenario 

Regards

Prabu