Webmaster Forum / ASP / Database Access / November 2007

Hello

We have recently upgraded to SQL Server 2005 but our connection string still
references SQLOLEDB.1.  (No I did not expect the SQL upgrade to upgrade our
connection strings!)

Having read this article,
(http://msdn2.microsoft.com/en-us/library/ms810810.aspx), it would seem that
there is no performance benefit to be gained by updating our connection
string to use the new Native Client.

Would anyone disagree with what Microsoft are saying here?

SQL Server Native Client is a data access technology that is new to
Microsoft SQL Server 2005, and it is a stand-alone data access application
programming interface (API) that is used for both OLE DB and ODBC. It
combines the SQL OLE DB Provider and the SQL ODBC Driver into one native
dynamic-link library (DLL), while providing also new functionality that is
separate and distinct from the Microsoft Data Access Components (MDAC). SQL
Server Native Client can be used to create new applications or enhance
existing applications that must take advantage of new SQL Server 2005
features such as Multiple Active Result Sets (MARS), User-Defined Types
(UDT), and XML data-type support.

Thanks

David