Home
%3CLINGO-SUB%20id%3D%22lingo-sub-892566%22%20slang%3D%22en-US%22%3EODBC%20Driver%2017.4.2%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-892566%22%20slang%3D%22en-US%22%3E%3CP%3EVersion%2017.4.2%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.4.2%20brings%20a%20few%20minor%20changes%20to%20the%20driver.%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1628218819%22%20id%3D%22toc-hId-1628274403%22%3EChanges%3C%2FH3%3E%3CUL%3E%3CLI%3E%3CSPAN%3EAzure%20Active%20Directory%20Authentication%20Library%20(adal.dll)%20is%20included%20in%20the%20ODBC%20driver%20installer%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EAdded%20additional%20accepted%20Azure%20Key%20Vault%20DNS%20endpoints%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--923938142%22%20id%3D%22toc-hId--923882558%22%3E%3CSPAN%3EFixes%3C%2FSPAN%3E%3C%2FH3%3E%3CUL%3E%3CLI%3E%3CSPAN%3EOn%20Linux%2C%20process%20ID%20and%20application%20name%20are%20now%20sent%20to%20SQL%20Server%20(for%20sys.dm_exec_sessions%20analysis)%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EOn%20Linux%2C%20removed%20redundant%20dependency%20on%20libuuid%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EFixed%20a%20bug%20when%20sending%20UTF-8%20data%20to%20SQL%20Server%202019%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3ELocales%20that%20end%20in%20%22%40euro%22%20were%20not%20being%20correctly%20detected%20(Linux)%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EXML%20data%20was%20being%20returned%20incorrectly%20when%20fetched%20as%20an%20output%20parameter%20while%20using%20Always%20Encrypted%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId-818872193%22%20id%3D%22toc-hId-818927777%22%3ENext%20steps%3C%2FH3%3E%3CP%3EFor%20Windows%20installations%2C%20you%20can%20download%20version%2017.4%20of%20the%20Microsoft%20ODBC%20Driver%2017%20for%20SQL%20Server%20from%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%20Download%20Center%3C%2FA%3E.%3CBR%20%2F%3E%3CBR%20%2F%3ELinux%20and%20macOS%20packages%20are%20also%20available.%20For%20installation%20details%20see%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fconnect%2Fodbc%2Flinux-mac%2Finstalling-the-microsoft-odbc-driver-for-sql-server%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eonline%20instructions%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId--1733284768%22%20id%3D%22toc-hId--1733229184%22%3ERoadmap%3C%2FH3%3E%3CP%3EWe%20are%20committed%20to%20improving%20quality%20and%20bringing%20more%20feature%20support%20for%20connecting%20to%20%3CA%20href%3D%22http%3A%2F%2Ftwitter.com%2Fsqlserver%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESQL%20Server%3C%2FA%3E%3CA%20href%3D%22http%3A%2F%2Ftwitter.com%2FAzureSQLDB%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20SQL%20Database%3C%2FA%3E%3CA%20href%3D%22http%3A%2F%2Ftwitter.com%2FAzureSQLDW%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20SQL%20DW%3C%2FA%3E%2C%20and%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-managed-instance%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20SQL%20Managed%20Instance%3C%2FA%3Ethrough%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%3Eor%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-892566%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20released%20an%20update%20to%20ODBC%20Driver%2017.4%20for%20SQL%20Server.%2017.4.2%20includes%20a%20few%20changes.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-892566%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

Version 17.4.2 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.4.2 brings a few minor changes to the driver.

Changes

  • Azure Active Directory Authentication Library (adal.dll) is included in the ODBC driver installer
  • Added additional accepted Azure Key Vault DNS endpoints

Fixes

  • On Linux, process ID and application name are now sent to SQL Server (for sys.dm_exec_sessions analysis)
  • On Linux, removed redundant dependency on libuuid
  • Fixed a bug when sending UTF-8 data to SQL Server 2019
  • Locales that end in "@euro" were not being correctly detected (Linux)
  • XML data was being returned incorrectly when fetched as an output parameter while using Always Encrypted

Next steps

For Windows installations, you can download version 17.4 of the Microsoft ODBC Driver 17 for SQL Server from the Microsoft Download Center.

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