More info about this provider can be found at the Microsoft product page. The SQL Server Native Client OLE DB provider is an OLE DB version 2.0–compliant provider. Note that it does not support features released with SQL Server 2014 and SQL Server 2016 that were not available as part of SQL Server 2012, such as Transparent Network IP Resolution, Always Encrypted, Azure AD Authentication, Bulk Copy and Table Value Parameters. SQL Server Native Client 11.0 provides OLE DB support to applications connecting to SQL Server versions 2005, 2008, 2008R2, 2012. Read more about when to use this provider in the article "When to use the SQL Native Client" in the artices section. The SQL Server Native Client OLE DB provider is a native, high performance provider that accesses the SQL Server Tabular Data Stream (TDS) protocol directly.
The SQL Server Native Client OLE DB provider is recommended for developing tools, utilities, or low-level components that need high performance.
#SQL SERVER 2016 NATIVE CLIENT DOWNLOAD UPDATE#
Note After future cumulative updates are released for SQL Server 2016, this CU can be located and downloaded from the Microsoft Windows Update Catalog.
#SQL SERVER 2016 NATIVE CLIENT DOWNLOAD DOWNLOAD#
If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package. The SQL Server Native Client OLE DB provider is a low-level COM API that is used for accessing data. Download the latest cumulative update package for SQL Server 2016 now. SQL Server Native Client version 11 was released with SQL Server 2012.
Include "Provider=SQLNCLI11" in the connection string to use this provider. The main functionality of the provider is contained in the file sqlncli11.dll. This OLE DB Provider is provided by Microsoft.