Database Topics (ODBC)

|  Overview |  How Do I |  FAQ |  Sample |  |  ODBC Driver List

The Microsoft Foundation Class Library (MFC) supplies classes for programming with Open Database Connectivity (ODBC). These classes are distinct from the newer MFC classes supplied for programming with Data Access Objects (DAO).

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?

What do you want to know more about?

• 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

• Structured Query Language (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?