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%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%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%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%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%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%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%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%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%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-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
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