CODEWITHSUNDEEP
sql-serverms-accessodbcdriverdatabase-connectivity
Brian Lorraine
Brian Lorraine

Reputation: 183

ODBC Driver for SQL Server vs SQL Server Native Client

If I use linked tables in Access 2010 to connect via ODBC to SQL Server 2014 Express, which driver is better?

enter image description here

The image shows the possibilities of drivers one can use while creating a new data source.

As per my re-search I found that the "Native Drivers" also supports OLEDB.

Can someone give an objective answer about which driver is better?

Upvotes: 1

Views: 15125

Answers (2)

user3200692
user3200692

Reputation: 87

SQL Server Native Client can be used for both SQL OLE DB provider and SQL ODBC driver for Windows. It depends on if you need to connect to SQL Server using both these 2 different methods.

The following 2 points should be noted when choosing SQL native client.

SNAC 11 is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver for Windows.

https://blogs.msdn.microsoft.com/sqlreleaseservices/snac-lifecycle-explained/

Also, you should notice that

OLE DB data access technology had been deprecated before. However, it is undeprecated now.

With this in mind, we have decided to undeprecate OLE DB data access technology, and release a new version by March 2018.

https://blogs.msdn.microsoft.com/sqlnativeclient/2017/10/06/announcing-the-new-release-of-ole-db-driver-for-sql-server/

Upvotes: 2

MachineGhost
MachineGhost

Reputation: 121

Native Client has been superseded by the ODBC Driver which Microsoft has standardized on. The Native Clients were originally for accessing features in Server 2005 and higher that the older ODBC driver ("SQL Server") could not access.

Upvotes: 1

Related Questions