SQL Server ODBC Driver

Question

When I create a new ODBC data source, I'm offered 4 different controllers to access SQL Server:

ODBC Driver 13 for SQL Server (Version 2017.140.1000.169)
SQL Server (Version 10.00.17763.01)
SQL Server Native Client 11.0 (Version 2011.110.6540.00)
SQL Server Native Client RDA 11.0 (Version 2011.110.5069.66)

What are the differences between them? Which is best/reccomended to connect to an SQL Server instance located in another computer through TCP/IP?

https://stackoverflow.com/questions/39440008/differences-between-drivers-for-odbc-drivers — Greg Askew, Jun 10 '19 at 16:44
Couldn't find that question as the title does not include the text "SQL Server". — Jordi, Jun 11 '19 at 13:12

score 0 · Accepted Answer · answered Jun 11 '19 at 13:17

For new development Microsoft recommends ODBC Driver for SQL Server.

Please see:

There are three distinct generations of Microsoft ODBC drivers for SQL Server. The first "SQL Server" ODBC driver still ships as part of Windows Data Access Components. It is not recommended to use this driver for new development. Starting in SQL Server 2005, the SQL Server Native Client includes an ODBC interface and is the ODBC driver that shipped with SQL Server 2005 through SQL Server 2012. It is not recommended to use this driver for new development. After SQL Server 2012, the Microsoft ODBC Driver for SQL Server is the driver that is updated with the most recent server features going forward.

SQL Server ODBC Driver

1 Answers1