ODBC1 - MFC

Begin ODBC

2025-12-19

Written by: xiaobin

In the long run, ODBC will inevitably replace OLE DB as the mainstream driver in MS SQL Server.

  1. Cross-platform
  2. similar to JDBC

SQL Server versions and ODBC and OLE DB drivers

SQL Server VersionODBC DriverOLE DB ProviderNotes
SQL Server 2000SQL Server ODBC Driver (legacy)SQL Server OLE DB Provider (legacy)Deprecated
SQL Server 2014Microsoft ODBC Driver 11 for SQL ServerSQL Native Client 11.0 (deprecated)SNAC/OLE DB deprecated
SQL Server 2016Microsoft ODBC Driver 13SQL Native Client 11.0 (deprecated)ODBC maintained OLE DB deprecated
SQL Server 2017Microsoft ODBC Driver 13.1 (14)SQL Native Client 11.0 (deprecated)OLE DB deprecated
SQL Server 2019Microsoft ODBC Driver 17Microsoft OLE DB Driver (MSOLEDBSQL)OLE DB undeprecated/reintroduced
SQL Server 2022Microsoft ODBC Driver 17Microsoft OLE DB Driver (MSOLEDBSQL)Actively maintained
SQL Server 2025Microsoft ODBC Driver 18Microsoft OLE DB Driver 19 (MSOLEDBSQL19)Actively maintained

Release Notes for Microsoft ODBC Driver for SQL Server on Windows

Cross-platform

Ref