%3CLINGO-SUB%20id%3D%22lingo-sub-1556980%22%20slang%3D%22en-US%22%3EODBC%20Driver%2017.6%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556980%22%20slang%3D%22en-US%22%3E%3CP%3EVersion%2017.6%20of%20the%20%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3Flinkid%3D867666%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20ODBC%20Driver%2017%20for%20SQL%20Server%3C%2FA%3E%26nbsp%3Bhas%20been%20released.%20Version%2017.6.1%20brings%20numerous%20new%20features%20and%20fixes%20to%20the%20driver.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1200958860%22%20id%3D%22toc-hId-1200958860%22%3EFeatures%3C%2FH3%3E%3CUL%3E%3CLI%3E%3CFONT%3ESupport%20Managed%20Identity%20authentication%20against%20Azure%20Key%20Vault%20when%20using%20Always%20Encrypted%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3ESupport%20ADFS%20with%20Azure%20Active%20Directory%20authentication%20on%20Linux%20and%20macOS%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3ESupport%20Azure%20Active%20Directory%20Integrated%20authentication%20on%20Linux%20and%20macOS%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3EAdded%20m%3CSPAN%3Eetadata%20caching%20for%20prepared%20statements%20to%20improve%20performance%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3ESend%20Server%20Name%20Indication%20during%20the%20TLS%20handshake%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3E%3CSPAN%3ENew%20SQL_COPT_SS_AUTOBEGINTXN%20connection%20attribute%20to%20control%20whether%20automatic%20BEGIN%20TRANSACTION%20happens%20after%20ROLLBACK%20or%20COMMIT%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3ESupport%20for%20Ubuntu%2020.04%3C%2FFONT%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--606495603%22%20id%3D%22toc-hId--606495603%22%3E%3CSPAN%3EFixes%3C%2FSPAN%3E%3C%2FH3%3E%3CUL%3E%3CLI%3EFixed%20a%20hang%20when%20a%20timeout%20occurred%20during%20an%20asynchronous%20notification%20operation%3C%2FLI%3E%3CLI%3E%3CSPAN%3EFixed%20driver%20reference%20count%20upon%20upgrade%20in%20Alpine%20Linux%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EFixed%20libc6%20dependency%20version%20for%20Ubuntu%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EAdded%20missing%20defines%20to%20Linux%2FmacOS%20msodbcsql.h%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3EFixed%20a%20collation%20issue%20with%20variant%20types%20when%20using%20bcp%3C%2FLI%3E%3CLI%3E%3CSPAN%3EFixed%20an%20error%20when%20authenticating%20with%20a%20federated%20account%20requiring%20a%20Conditional%20Access%20policy%20(Windows)%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId-1881017230%22%20id%3D%22toc-hId-1881017230%22%3E%26nbsp%3B%3C%2FH3%3E%3CH3%20id%3D%22toc-hId-73562767%22%20id%3D%22toc-hId-73562767%22%3ENext%20steps%3C%2FH3%3E%3CP%3EFor%20Windows%20installations%2C%20you%20can%20directly%20-ERR%3AREF-NOT-FOUND-download%20the%20Microsoft%20ODBC%20Driver%2017%20for%20SQL%20Server.%3CBR%20%2F%3E%3CBR%20%2F%3ELinux%20and%20macOS%20packages%20are%20also%20available.%20For%20installation%20details%20see%20the%20-ERR%3AREF-NOT-FOUND-online%20instructions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId--1733891696%22%20id%3D%22toc-hId--1733891696%22%3ERoadmap%3C%2FH3%3E%3CP%3EWe%20are%20committed%20to%20improving%20quality%20and%20bringing%20more%20feature%20support%20for%20connecting%20to%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fsqlserver%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESQL%20Server%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2FAzureSQLDB%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20SQL%20Database%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FAzure_Synapse_Analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Synapse%20Analytics%3C%2FA%3E%2C%20and%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FAzureSQLMI%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20SQL%20Managed%20Instance%3C%2FA%3E%20through%20regular%20driver%20releases.%20We%20invite%20you%20to%20explore%20the%20latest%20the%20Microsoft%20Data%20Platform%20has%20to%20offer%20via%20a%20trial%20of%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fservices%2Fsql-database%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Azure%20SQL%20Database%3C%2FA%3E%20or%20by%20evaluating%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fevalcenter%2Fevaluate-sql-server%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20SQL%20Server%3C%2FA%3E.%3CBR%20%2F%3E%3CBR%20%2F%3EDavid%20Engel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1556980%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20released%20ODBC%20Driver%2017.6%20for%20SQL%20Server.%2017.6%20includes%20numerous%20new%20features%20and%20fixes.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1556980%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

Version 17.6 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.6.1 brings numerous new features and fixes to the driver.

 

Features

  • Support Managed Identity authentication against Azure Key Vault when using Always Encrypted
  • Support ADFS with Azure Active Directory authentication on Linux and macOS
  • Support Azure Active Directory Integrated authentication on Linux and macOS
  • Added metadata caching for prepared statements to improve performance
  • Send Server Name Indication during the TLS handshake
  • New SQL_COPT_SS_AUTOBEGINTXN connection attribute to control whether automatic BEGIN TRANSACTION happens after ROLLBACK or COMMIT
  • Support for Ubuntu 20.04

Fixes

  • Fixed a hang when a timeout occurred during an asynchronous notification operation
  • Fixed driver reference count upon upgrade in Alpine Linux
  • Fixed libc6 dependency version for Ubuntu
  • Added missing defines to Linux/macOS msodbcsql.h
  • Fixed a collation issue with variant types when using bcp
  • Fixed an error when authenticating with a federated account requiring a Conditional Access policy (Windows)

 

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