open-database-connectivity-odbc.md

title	ms.custom	ms.date	ms.reviewer	ms.suite	ms.technology	ms.tgt_pltfrm	ms.topic	dev_langs	helpviewer_keywords	ms.assetid	caps.latest.revision	author	ms.author	manager
Open Database Connectivity (ODBC) | Microsoft Docs		11/04/2016			cpp-windows		article	C++	ODBC [C++] databases [C++], ODBC data access [C++], ODBC	56b6067a-651e-4c10-a24d-d4a6a17ca5e4	10	mikeblome	mblome	ghogen

Open Database Connectivity (ODBC)

The Microsoft Foundation Classes (MFC) library supplies classes for programming with Open Database Connectivity (ODBC). As of Visual Studio 2015 and SQL Server 2012 ODBC is the preferred way to connect to SQL data sources.

For more information about using the ODBC API without MFC, see the Open Database Connectivity (ODBC) SDK in MSDN.

In This Section

• ODBC—the Open Database Connectivity standard and API

• What MFC Support Is Supplied for ODBC programming

• What ODBC Drivers Are Available

• Connecting to ODBC Data Sources

• Record Field Exchange (RFX) between a database and a recordset object

• ODBC Recordsets

• SQL for ODBC

• Database Transactions

• Determining the Schema of an ODBC Data Source at run time

• Programmatically Configuring an ODBC Data Source

• Programmatically Creating a Table in an ODBC Data Source

• Fetching Records in Bulk

• Customizing my Recordset's SQL Statement

• Making Direct SQL Calls

• Making Direct Calls to the ODBC API

• How do the database classes work with MFC's document/view architecture?

• ODBC Driver List

ODBC Database Tasks

These tasks are based on the MFC ODBC classes. For more information about using the ODBC API without MFC, see the Open Database Connectivity (ODBC) SDK.

• Install and Get Started with ODBC

• Design and Create an ODBC Database Application

• Use Database Forms (Record Views) with ODBC

• Use ODBC to Work with Other Users

• Work with ODBC Database Connections

• Work with ODBC and Drivers

• Use the ODBC Cursor Library

• Use MFC ODBC Recordsets

See Also

Data Access Programming (MFC/ATL)