ODBC Driver 17.7 for SQL Server Released

This article is contributed. See the original author and article here.

Version 17.7 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.7.1 brings several new features and fixes to the driver.

Features

• Support Azure Active Directory Interactive authentication (Windows-only) against Azure Key Vault when using Always Encrypted
• Support Azure Active Directory Service Principal authentication
• Support for inserting into encrypted money and smallmoney columns
• Support for Ubuntu 20.10
• Support for Oracle Linux 7
• Support for macOS 11 (Big Sur)
• Support for Alpine Linux 3.12

Fixes

• Fixed character encoding of VARIANT columns in BCP NATIVE mode
• Fixed setting of SQL_ATTR_PARAMS_PROCESSED_PTR under specific conditions
• Fixed SQLDescribeParam in FMTONLY mode for statements containing comments
• Fixed an issue with federated authentication when using Okta
• Fixed excessive memory usage on multi-processor systems
• Fixed Azure AD authentication against some variants of Azure SQL Database

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 Synapse Analytics, 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

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.