SQL Native Client (SNAC)

Eintrag zuletzt aktualisiert am: 28.07.2019

SQL Native Client (SNAC und auch SQLNCLI) ist eine Client-Bibliothek für den Zugriff auf Microsoft SQL Server, die es seit 2005 gibt.
Sie ist eine Zugriffskomponente für Clients auf den SQL Server, die nicht von MDAC (Microsoft Data Access Components) abhängig ist. SNAC implementiert Tabular Data Stream (TDS) direkt.

Connection-String-Beispiel

Provider=SQLNCLI11; Server=myServerName\theInstanceName;Database=myDataBase;
Trusted_Connection=yes;

Veraltert

"SQL Server Native Client is a stand-alone library that is used for both OLE DB and ODBC. SQL Server Native Client (often abbreviated SNAC) was included in SQL Server 2005 through 2012. SQL Server Native Client can be used for applications that need to take advantage of new features introduced in SQL Server 2005 through SQL Server 2012. (Microsoft/Windows Data Access Components are not updated for these new features in SQL Server.) For new features beyond SQL Server 2012, SQL Server Native Client will not be updated. Switch to the Microsoft ODBC Driver for SQL Server or the Microsoft OLE DB Driver for SQL Server if you want to take advantage of new SQL Server features going forward."
[https://docs.microsoft.com/en-us/sql/connect/connect-history?view=sqlallproducts-allversions#Microsoft/Windows%20Data%20Access%20Components%20(MDAC/WDAC)]

"The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features."
[https://docs.microsoft.com/en-us/sql/relational-databases/native-client/sql-server-native-client?view=sql-server-2017]