Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1144995%22%20slang%3D%22en-US%22%3EODBC%20Driver%2017.5%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1144995%22%20slang%3D%22en-US%22%3E%3CP%3EVersion%2017.5%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20ODBC%20Driver%2017%20for%20SQL%20Server%3C%2FA%3E%26nbsp%3Bhas%20been%20released.%20Version%2017.5.1%20brings%20a%20few%20new%20features%20and%20a%20handful%20of%20fixes%20to%20the%20driver.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1085513771%22%20id%3D%22toc-hId-1085513771%22%20id%3D%22toc-hId-1085513771%22%20id%3D%22toc-hId-1085513771%22%20id%3D%22toc-hId-1085513771%22%20id%3D%22toc-hId-1085513771%22%3EFeatures%3C%2FH3%3E%3CUL%3E%3CLI%3E%3CFONT%3ENew%20SQL_COPT_SS_SPID%20connection%20attribute%20provides%20SPID%20without%20a%20round-trip%20to%20the%20server%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3ESupport%20for%20indicating%20EULA%20acceptance%20via%20debconf%20on%20Debian%20and%20Ubuntu%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3ESupport%20for%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fconnect%2Fodbc%2Flinux-mac%2Finstalling-the-microsoft-odbc-driver-for-sql-server%23redhat-enterprise-server-and-oracle-linux%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAlpine%20Linux%3C%2FA%3E%20(3.10%20and%203.11)%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3ESupport%20for%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fconnect%2Fodbc%2Flinux-mac%2Finstalling-the-microsoft-odbc-driver-for-sql-server%23redhat-enterprise-server-and-oracle-linux%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOracle%20Linux%3C%2FA%3E%208%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3ESupport%20for%20Ubuntu%2019.10%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3ESupport%20for%20macOS%20Catalina%20(10.15)%3C%2FFONT%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--721940692%22%20id%3D%22toc-hId--721940692%22%20id%3D%22toc-hId--721940692%22%20id%3D%22toc-hId--721940692%22%20id%3D%22toc-hId--721940692%22%20id%3D%22toc-hId--721940692%22%3E%3CSPAN%3EFixes%3C%2FSPAN%3E%3C%2FH3%3E%3CUL%3E%3CLI%3E%3CFONT%3EFixed%20AKV%20CMK%20metadata%20hash%20computation%20on%20Linux%2FMac%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3EFixed%20error%20when%20loading%20OpenSSL%201.0.0%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3EFixed%20conversion%20issues%20when%20using%20ISO-8859-1%20and%20ISO-8859-2%20codepages%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3EFixed%20internal%20library%20name%20on%20Mac%20to%20include%20version%20number%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%3EFixed%20setting%20of%20null%20indicator%20when%20separate%20length%20and%20indicator%20bindings%20are%20used%3C%2FFONT%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20Linux%20packages%20for%2017.5%20were%20briefly%20unavailable%20due%20an%20issue%20in%20the%20mssql-tools%20package%20but%20are%20now%20available%20(4%20Feb)%20with%20an%20updated%20mssql-tools%20package.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1765572141%22%20id%3D%22toc-hId-1765572141%22%20id%3D%22toc-hId-1765572141%22%20id%3D%22toc-hId-1765572141%22%20id%3D%22toc-hId-1765572141%22%20id%3D%22toc-hId-1765572141%22%3ENext%20steps%3C%2FH3%3E%3CP%3EFor%20Windows%20installations%2C%20you%20can%20directly%20%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3Flinkid%3D867666%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edownload%20the%20Microsoft%20ODBC%20Driver%2017%20for%20SQL%20Server%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%20noopener%20noreferrer%20noopener%20noreferrer%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--41882322%22%20id%3D%22toc-hId--41882322%22%20id%3D%22toc-hId--41882322%22%20id%3D%22toc-hId--41882322%22%20id%3D%22toc-hId--41882322%22%20id%3D%22toc-hId--41882322%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%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%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-1144995%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20released%20ODBC%20Driver%2017.5%20for%20SQL%20Server.%2017.5%20includes%20a%20few%20new%20features%20and%20a%20handful%20of%20fixes.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1144995%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1214352%22%20slang%3D%22en-US%22%3ERe%3A%20ODBC%20Driver%2017.5%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1214352%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20of%20March%206%2C%20the%20direct%20download%20link%20in%20this%20article%20(%3CA%20title%3D%22Microsoft%20ODBC%20Driver%2017%20for%20SQL%20Serer%22%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3Flinkid%3D867666%3C%2FA%3E)%20is%20broken%2C%20and%20it%20appears%20v17.5.2.1%20has%20been%20released.%26nbsp%3B%20Are%20there%20any%20release%20notes%20as%20to%20what's%20changed%3F%26nbsp%3B%20Also%2C%20are%20there%20any%20ways%20to%20download%20older%20versions%20(v17.2%2C%20v17.3)%20for%20compatibility%20testing%3F%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1214397%22%20slang%3D%22en-US%22%3ERe%3A%20ODBC%20Driver%2017.5%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1214397%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F576297%22%20target%3D%22_blank%22%3E%40BobPaul%3C%2FA%3EYou%20probably%20hit%20the%20download%20site%20as%2017.5.2.1%20was%20syncing%20out%20to%20all%20the%20servers.%20It%20was%20just%20released.%20It%20may%20take%20an%20hour%20or%20so%20to%20sync%20to%20all%20caches.%20Docs%2C%20including%20release%20notes%2C%20should%20appear%20on%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fconnect%2Fodbc%2Fwindows%2Frelease-notes-odbc-sql-server-windows%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edocs%20site%3C%2FA%3E%20sometime%20this%20afternoon.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20for%20download%20links%20to%20older%20versions%2C%20look%20for%20those%20on%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fconnect%2Fodbc%2Fwindows%2Frelease-notes-odbc-sql-server-windows%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edocs%20release%20notes%20page%3C%2FA%3E%20in%20a%20week%20or%20so%20(I'm%20working%20on%20it).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EDavid%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1223553%22%20slang%3D%22en-US%22%3ERe%3A%20ODBC%20Driver%2017.5%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1223553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F576297%22%20target%3D%22_blank%22%3E%40BobPaul%3C%2FA%3E%26nbsp%3BChanges%20are%20up.%20The%20docs%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fconnect%2Fodbc%2Fdownload-odbc-driver-for-sql-server%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Edownload%20page%3C%2FA%3E%20has%20been%20revamped%20and%20you%20can%20download%20previous%20versions%20from%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fconnect%2Fodbc%2Fwindows%2Frelease-notes-odbc-sql-server-windows%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edocs%20release%20notes%20page%3C%2FA%3E%26nbsp%3Bnow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EDavid%3C%2FP%3E%3C%2FLINGO-BODY%3E
Senior Member

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

3 Comments
Occasional Visitor

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.

Senior Member

@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

Senior Member

@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