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

Published: 4/2012

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.

 

 

To review the document, please download the Converting SQL Server Applications from OLE DB to ODBC Word document.

Ask a question in the SQL Server Forums