Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the SQL Native Client?

April 26, 2017client native sql

0

Posted

What is the SQL Native Client?

1 Answer

0

Posted

The SQL Native Client is a new OLE DB and ODBC API that provides data access providers with new functionality and datatypes provided by SQL Server 2005. By using SQL Native Client, applications can make use of features such as Multiple Active Result Sets (MARS), SQL Server 2005’s XML datatype and CLR user- defined datatypes, and SQL Service Broker. Developers using .NET languages such as C# or VB.NET in conjunction with ADO.NET will not need to worry about the SQL Native Client—all of the features it exposes are present in the ADO.NET classes. However, developers programming COM-based applications that need to access SQL Server 2005 databases may wish to expand their functionality by using the SQL Native Client for data access. Return to features and functions FAQs 7.