ODBC Driver for SQL Server vs SQL Server Native Client

sql-server ms-access odbc driver database-connectivity
Brian Lorraine picture Brian Lorraine · Aug 13, 2015 · Viewed 11k times · Source

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

  • ODBC Driver 11 for SQL Server
  • SQL Server Native Client 11.0

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?

Answer

MachineGhost picture MachineGhost · Jul 22, 2016

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.

Related questions

MS Access call SQL Server stored procedure

I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code or query I work with those tables very simple, I access them via name, like [Customers]. Also I have a …

Read More
How do I create a table alias in MySQL

I am migrating an MS Access application (which has linked tables to a MSSQL Server) to MySQL. As a means to overcome some MSAccess table naming problems, I am seeking a solution to add a MySQL table alias that will …

Read More
Editing Record issues in Access / SQL (Write Conflict)

a problem has come up after a SQL DB I used was migrated to a new server. Now when trying to edit a record in Access (form or table), it says: WRITE CONFLICT: This record has been changed by another …

Read More