There are four components in the ODBC architecture:
The application component defines and performs
the work to be accomplished. It calls the ODBC API functions that
submit SQL statements and retrieve results.
The driver manager component loads drivers
on behalf of an application.
The driver component processes ODBC function
calls, submits SQL requests to a specific data source, and passes
results to the application. The driver transforms the application's
SQL syntax into the syntax expected by the driver's associated DBMS.
The data source component is the data to
be accessed and the means for doing so, including the associated operating
system, DBMS and network platform.
From the application program's perspective, the driver manager
and the driver appear to be a single unit for processing ODBC function
calls. ODBC
Components shows the relationship between the
four components:
Figure 1. ODBC
Components
