May 26, 2014 at 4:40 am
Hi,
we used SQL Server 2012.
We have several own developed applications under Access and other 3rd Party Tools that connected to our Database Server via ODBC.
Now I have seen, that i have two different ODBC Drivers available.
First the SQL Server Driver (SQLSRV32.DLL) of Nov.2011 and the SQL Native Client 11 (SQLNCLI11.DLL) of march 2014.
Which one is the better choice and can i switch without changing my applications. I tend to the native Client because it seems to be patched with every SP an it is the newer one..
Is There any advantages if i used the Native Client. What are the differences between these two drivers...
Thank you in advance.. 😀
Best Regards..
May 28, 2014 at 10:51 am
SNAC was introduced all the way back in SQL Server 2005. "SQL Server Native Client combines the SQL OLE DB provider and the SQL ODBC driver into one native dynamic-link library (DLL)." In particular, SNAC supports MARS, multiple active result sets.
The SQL Server Native Client...
http://msdn.microsoft.com/en-us/data/ff658532.aspx
Windows Data Access Components (WDAC), previously called Microsoft Data Access Components (MDAC), is the more generic ODBC driver (sqlsrv32.dll). Probably the better choice if you need to write generic, non-application-specific data connections. If you are only coding for Microsoft SQL Server data connections, then SNAC is better.
May 28, 2014 at 11:00 am
This link should provide all the info you need to compare the 2 drivers:
Updating an Application to SQL Server Native Client from MDAC
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply