Skip to content

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

Latest commit

 

History

History
54 lines (41 loc) · 3.6 KB

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

File metadata and controls

54 lines (41 loc) · 3.6 KB
title Microsoft ODBC Driver for SQL Server on Windows
description Learn about creating applications that use the Microsoft ODBC Driver for SQL Server on Windows.
author David-Engel
ms.author davidengel
ms.reviewer maghan
ms.date 09/19/2024
ms.service sql
ms.subservice connectivity
ms.topic concept-article

Microsoft ODBC Driver for SQL Server on Windows

[!INCLUDE Driver_ODBC_Download]

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

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 [!INCLUDE ssNoVersion].

Summary

Version Features Supported
Microsoft ODBC Driver 18 for SQL Server
  • Support for TDS 8.0
  • Extensions to SQLGetData
  • Option to send SQL_LONG_* types as (max)-types
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
  • Microsoft Entra authentication
  • Always On 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 [!INCLUDE ssNoVersion] includes:

Community

Related content