Converting SQL Server Applications from OLE DB to ODBC
Microsoft® SQL Server® Technical Article
Writers: Anton Klimov, George Yan, Kun Cheng
Technical Reviewers: Kevin Cox, Prem Mehra, Steve Howard
Applies to: SQL Server 2012
Summary: Microsoft has announced the deprecation of the SQL Server Native Client OLE DB provider, and that SQL Server 2012 is the last version of SQL Server to support the provider. This article provides guidance for converting SQL Server or SQL Azure applications that use OLE DB to the ODBC API. The article presents an overview of ODBC and discusses the main differences between the two APIs. Sample code is also provided to demonstrate the API level mapping and conversion.