Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inNote
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
We are pleased to announce an update to the Microsoft ODBC Driver 17 for SQL Server! Version 17.2 brings a few added features and several fixed issues.
- Support for Data Discovery and Classification information on Azure SQL Database and SQL Server
- Support for UTF-8 server encoding
- Support for Ubuntu 18.04
- Idle Connection Resiliency support has been extended to Linux and macOS
- The ConnectRetryCount and ConnectRetryInterval keywords can be specified in the connection string
- Use
SQL_COPT_SS_CONNECT_RETRY_COUNT(read only) to retrieve the number of connection retry attempts - Use
SQL_COPT_SS_CONNECT_RETRY_INTERVAL(read only) to retrieve the length of the connection retry interval - Connections will be retried once by default
- Use
- The ConnectRetryCount and ConnectRetryInterval keywords can be specified in the connection string
- SQLBrowseConnect is now supported on Linux and macOS
- On Linux and macOS, dynamic dependency on
libcurl:- Starting with version 17.2, the
libcurlpackage is not an explicit package dependency. Thelibcurlpackage for OpenSSL or NSS is required when using Azure Key Vault or Azure Active Directory authentication. If you encounter an error regardinglibcurl, ensure it is installed.
- Starting with version 17.2, the
This release also contains the following fixed issues:
- Fixed an error message about Azure Active Directory Authentication
- Fixed encoding detection when locale environment variables are set differently
- Fixed a crash upon disconnect when connection recovery is in progress
- Fixed detection of connection liveness
- Fixed incorrect detection of closed sockets
- Fixed an infinite wait when attempting to release a statement handle during a failed recovery
- Fixed incorrect uninstallation behavior when both version 13 and 17 are installed on Windows
- Fixed incorrect decryption behavior on older Windows platforms (Windows 7, 8 and Server 2012)
- Fixed a cache issue when using ADAL Authentication on Windows
- Fixed an issue which was locking and overwriting trace logs on Windows
For Windows installations, you can download version 17.2 of the Microsoft ODBC Driver 17 for SQL Server here.
Linux and macOS packages are also available. For installation details see the online instructions.
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