Open Database Connectivity (ODBC)

The new home for Visual Studio documentation is Visual Studio 2017 Documentation on docs.microsoft.com.

The latest version of this topic can be found at Open Database Connectivity (ODBC).

The Microsoft Foundation Classes (MFC) library supplies classes for programming with Open Database Connectivity (ODBC).

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

Frequently Asked Questions About MFC Database Support

• What data sources can I access with DAO and ODBC?

• Can I call DAO or ODBC APIs directly while using the classes?

• What ODBC drivers are provided?

• What ODBC drivers are installed by default?

In This Section

• ODBC—the Open Database Connectivity standard and API

• What MFC Support Is Supplied for ODBC programming

• What ODBC Drivers Are Available

• Installing MFC ODBC Support

• Should I Use DAO or ODBC?

• 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)