Microsoft Sql Server Native Client — 2012 Verified

While Microsoft has since moved toward modern data access technologies like the and the ODBC Driver for SQL Server , SQL Server Native Client 2012 remains an important component for maintaining legacy systems and applications built around this specific driver.

Enabling (Multiple Active Result Sets):

Provider=SQLNCLI11;Server=myServer\instance;Database=myDB;Trusted_Connection=yes;

| Property | Value | |----------|-------| | Full name | Microsoft SQL Server 2012 Native Client | | DLL name | SQLNCLI11.DLL | | Version number | 11.0.x | | Deprecation status | Deprecated | | Replaced by | Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) / ODBC Driver 17+ |

It is specifically built to leverage features introduced in SQL Server 2012 , such as AlwaysOn availability groups and enhanced disaster recovery.