Compared with OLDEDB provider, SQL Native Client provider is a low-level, COM API that is used for accessing data. It is recommended for developing tools, utilities, or low-level components that need high performance and it accesses the SQL Server Tabular Data Stream (TDS) protocol directly.
On the other hands, I'm not sure how you handle with your OLEDB provider. OLEDB used to be included along with the other client libraries in a separate installable piece called MDAC (Microsoft Data access Client). But in SQL 2008 that package is called SNAC (SQL Native Access Components).
SNAC is available as part of the SQL Server 2008 Feature Pack.
http://www.microsoft.com/downloads/details.aspx?FamilyID=228de03f-3b5a-428a-923f-58a033d316e1&displaylang=en
Scroll down to the SQL Server 2008 Native Client and select the package appropriate to your install.
No comments:
Post a Comment