Lokasi ngalangkungan proxy:   [ UP ]  
[Ngawartoskeun bug]   [Panyetelan cookie]                
Skip to content

Latest commit

 

History

History
98 lines (87 loc) · 17.3 KB

File metadata and controls

98 lines (87 loc) · 17.3 KB
title Driver feature support matrix
description Learn which popular features are supported in drivers for SQL Server and where to find information about them.
ms.custom
ms.date 01/29/2021
ms.prod sql
ms.technology connectivity
ms.topic conceptual
author David-Engel
ms.author v-daenge
ms.reviewer v-daenge

Driver feature support matrix for Microsoft SQL Server

If you're planning to use a feature in Microsoft SQL Server, it might not be available in all drivers. Some reasons a feature might not be in a particular driver include:

  • The feature doesn't apply to the driver technology.
  • The feature is new and hasn't been implemented across all drivers yet.
  • The feature isn't in demand in a particular driver.
  • Other features are being implemented first.

We wish all drivers supported every feature and spend effort to ensure feature parity across drivers. However that isn't always possible. To help you choose the appropriate driver for your needs, here's a list of popular features and the drivers that implement them.

Feature Microsoft.Data.SqlClient (.NET Core) Microsoft.Data.SqlClient (.NET Framework) System.Data.SqlClient (.NET Core) System.Data.SqlClient (.NET Framework)
Always Encrypted Yes Yes Yes
Always Encrypted with secure enclaves Yes Yes Yes
Azure Active Directory Access Token authentication Yes Yes Yes Yes
Azure Active Directory Password authentication Yes Yes Yes
Azure Active Directory Integrated authentication Yes Yes Yes
Azure Active Directory Interactive (MFA) authentication Yes Yes Yes
Azure Active Directory Managed Identity authentication Yes Yes
Azure Active Directory Service Principal authentication Yes Yes
Windows-Integrated authentication Yes Yes Yes Yes
Bulk Copy Yes Yes Yes Yes
Data Sensitivity and Classification metadata Yes Yes Yes Yes
Multiple Active Result Sets (MARS) Yes Yes Yes Yes
Spatial Data Types Yes Yes
Table-Valued Parameters (TVP) Yes Yes Yes Yes
MultiSubnetFailover Yes Yes Yes Yes
Transparent Network IP Resolution Yes Yes
         
Feature ODBC Driver for SQL Server on Windows ODBC Driver for SQL Server on Linux and macOS JDBC Driver for SQL Server OLE DB Driver for SQL Server
Always Encrypted Yes Yes Yes
Always Encrypted with secure enclaves Yes Yes Yes
Azure Active Directory Access Token authentication Yes Yes Yes Yes
Azure Active Directory Password authentication Yes Yes Yes Yes
Azure Active Directory Integrated authentication Yes Yes Yes Yes
Azure Active Directory Interactive (MFA) authentication Yes Yes Yes
Azure Active Directory Managed Identity authentication Yes Yes Yes Yes
Azure Active Directory Service Principal authentication Yes Yes Yes Yes
Windows-Integrated authentication Yes Yes Yes Yes
Bulk Copy Yes Yes Yes Yes
Data Discovery and Classification metadata Yes Yes Yes
Multiple Active Result Sets (MARS) Yes Yes Yes
Spatial Data Types Yes
Table-Valued Parameters (TVP) Yes Yes Yes Yes
MultiSubnetFailover Yes Yes Yes Yes
Transparent Network IP Resolution Yes Yes Yes Yes
         
Feature Drivers for PHP for SQL Server on Windows1 Drivers for PHP for SQL Server on Linux and macOS1 Tedious (Node.js) pyODBC (Python)1
Always Encrypted Yes Yes Yes
Always Encrypted with secure enclaves Yes Yes Yes
Azure Active Directory Access Token authentication Yes Yes Yes Yes
Azure Active Directory Password authentication Yes Yes Yes Yes
Azure Active Directory Integrated authentication Yes Yes Yes
Azure Active Directory Interactive (MFA) authentication Yes2
Azure Active Directory Managed Identity authentication Yes Yes Yes Yes
Azure Active Directory Service Principal authentication
Windows-Integrated authentication Yes Yes Yes
Bulk Copy Yes
Data Discovery and Classification metadata Yes Yes
Multiple Active Result Sets (MARS) Yes Yes Yes
Spatial Data Types
Table-Valued Parameters (TVP) Yes Yes
MultiSubnetFailover Yes Yes Yes
Transparent Network IP Resolution Yes Yes Yes
         

1 Since these drivers rely on the Microsoft ODBC Driver for SQL Server, a version of that driver that supports the feature must also be used.

2 Only on Windows.

[!INCLUDEget-help-options]

[!INCLUDEcontribute-to-content]