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) documentation.

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)