microsoft-odbc-driver-for-sql-server-on-windows.md

title	Microsoft ODBC Driver for SQL Server on Windows | Microsoft Docs
ms.custom
ms.date	02/14/2018
ms.prod	sql
ms.prod_service	connectivity
ms.reviewer
ms.technology	connectivity
ms.topic	conceptual
ms.assetid	b10cfc22-6a2c-4707-a456-0dcec317982b
author	David-Engel
ms.author	v-daenge

Microsoft ODBC Driver for SQL Server on Windows

[!INCLUDEDriver_ODBC_Download]

The Microsoft ODBC Drivers for [!INCLUDEssNoVersion] are stand-alone ODBC drivers which provide an application programming interface (API) implementing the standard ODBC interfaces to Microsoft [!INCLUDEssNoVersion].

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 SQL Data Warehouse, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.

Summary

Version	Features Supported
Microsoft ODBC Driver 17 for SQL Server	Always Encrypted support for BCP API New connection string attribute UseFMTONLY causes driver to use legacy metadata in special cases requiring temp tables
Microsoft ODBC Driver 13.1 for SQL Server	Always Encrypted Azure AD Authentication AlwaysOn Availability Groups (AG)
Microsoft ODBC Driver 13 for SQL Server	Internationalized Domain Name (IDN)
Microsoft ODBC Driver 11 for SQL Server	Driver-Aware Connection Pooling Connection Resiliency Asynchronous execution (Polling Method)

Documentation

This documentation for the Microsoft ODBC Driver for [!INCLUDEssNoVersion] includes:

• Release Notes for ODBC to SQL Server on Windows
• Features of the Microsoft ODBC Driver for SQL Server on Windows
• System Requirements, Installation, and Driver Files
• Driver-Aware Connection Pooling in the ODBC Driver for SQL Server
• Asynchronous Execution (Notification Method) Sample
• Connection Resiliency in the Windows ODBC Driver
• Using Always Encrypted with the ODBC Driver
• Using Azure Active Directory with the ODBC Driver
• Using Transparent Network IP Resolution

Community

• Microsoft ODBC Driver For SQL Server Team blog
• SQL Server Data Access Forum

See Also

• About SQL Server Native Client
• Building Applications with SQL Server Native Client
• SQL Server Native Client FAQ
• ODBC Programmer's Reference
• SQL Server Native Client (ODBC)