Microsoft ODBC Driver 17 for SQL Server logo

Microsoft ODBC Driver 17 for SQL Server Microsoft Corporation

Use this command to install Microsoft ODBC Driver 17 for SQL Server:
winget install --id=Microsoft.msodbcsql.17 -e

The Microsoft ODBC Drivers for SQL Server are stand-alone ODBC drivers which provide an application programming interface (API) implementing the standard ODBC interfaces to Microsoft SQL Server. The Microsoft ODBC Driver for SQL Server can be used to create new applications. You can also upgrade your older applications which currently use an older ODBC driver. The ODBC Driver for SQL Server supports connections to Azure SQL Database, Azure Synapse Analytics, and SQL Server.

Microsoft ODBC Driver 17 for SQL Server is a driver designed to provide connectivity between applications and Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics. It implements the standard ODBC interfaces, enabling developers to create new applications or upgrade existing ones that use older ODBC drivers.

Key Features:

  • Connection resiliency to ensure robust communication with SQL Server.
  • Support for Always Encrypted, enhancing data security by encrypting sensitive information both at rest and in transit.
  • Tools like sqlcmd for running Transact-SQL statements and system procedures, and bcp for bulk copying data between SQL Server instances and files.

Audience & Benefit:
Ideal for developers building applications using C++, COBOL, Perl, PHP, or Python to streamline connectivity with SQL Server and Azure-based databases. It simplifies development workflows and enhances data security and performance.

The driver can be installed via winget.

Versions
17.10.6.1