By switching to MSOLEDBSQL , you future-proof your legacy applications for modern Azure and SQL Server environments.
The is the current, stand-alone data access API used to connect applications to SQL Server. Released in 2018 after being "undeprecated," it serves as the modern replacement for the older SQL Server Native Client (SNAC) and the legacy Windows Data Access Components (WDAC/MDAC). Key Features & Versions microsoft ole db driver for sql server
Full support for Microsoft Entra ID (formerly Azure Active Directory), Always Encrypted, and TLS 1.3 in the latest versions. Evolution and Versioning By switching to MSOLEDBSQL , you future-proof your
Allows multiple queries to be executed over a single connection without finishing the previous one. Key Features & Versions Full support for Microsoft
If you are building a new application, prefer the library (which is ADO.NET native). However, use MSOLEDBSQL if:
Previous major version; can be installed side-by-side with version 19.