ODBC

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

In addition to an overview of Open Database Connectivity (ODBC), this article explains:

• How ODBC works with the database classes.
  
  
• How ODBC drivers work with dynasets.
  
  
• What ODBC components you need to redistribute with your applications.

You will also want to read the related article ODBC: The ODBC Cursor Library.

Notes   ODBC data sources are accessible through the MFC ODBC classes, as described in this article, or through the MFC Data Access Object (DAO) classes. For information about the DAO classes, see the article DAO and MFC.

The MFC ODBC classes support Unicode and multithreading. For more information about the multithreading support, see the article ODBC Classes and Threads

ODBC is a call-level interface that allows applications to access data in any database for which there is an ODBC driver. Using ODBC, you can create database applications with access to any database for which your end-user has an ODBC driver. ODBC provides an API that allows your application to be independent of the source database management system (DBMS).

ODBC is the database portion of the Microsoft Windows Open Services Architecture (WOSA), an interface which allows Windows-based desktop applications to connect to multiple computing environments without rewriting the application for each platform.

The following are components of ODBC:

• ODBC API

  A library of function calls, a set of error codes, and a standard Structured Query Language (SQL) syntax for accessing data on DBMSs.

• ODBC Driver Manager

  A dynamic-link library (ODBC32.DLL) that loads ODBC database drivers on behalf of an application. This DLL is transparent to your application.

• ODBC database drivers

  One or more DLLs that process ODBC function calls for specific DBMSs. For a list of supplied drivers, see the article ODBC Driver List.

• ODBC Cursor Library

  A dynamic-link library (ODBCCR32.DLL) that resides between the ODBC Driver Manager and the drivers and handles scrolling through the data.

• ODBC Administrator

  A tool used for configuring a DBMS to make it available as a data source for an application.

An application achieves independence from DBMSs by working through an ODBC driver written specifically for a DBMS rather than working directly with the DBMS. The driver translates the calls into commands its DBMS can use, simplifying the developer’s work, and making it available for a wide range of data sources.

The database classes support any data source for which you have an ODBC driver. This might, for example, include a relational database, an Indexed Sequential Access Method (ISAM) database, a Microsoft Excel spreadsheet, or a text file. The ODBC drivers manage the connections to the data source, and SQL is used to select records from the database.

See the article ODBC Driver List for a list of ODBC drivers included in this version of Visual C++ and for information about obtaining additional drivers.

The ODBC Software Development Kit (SDK) is provided on the MSDN Library CD. For more information on ODBC, see the ODBC SDK Programmer’s Reference, and the ODBC API Reference Help system.