How Does ODBC Work?

The ODBC architecture has four components that work together to process and call functions, load drivers, and return results to the application.

The ODBC architecture has four components:

• Application, which processes and calls ODBC functions to submit SQL statements and retrieve results
• Driver Manager, which loads drivers for the application
• Driver, which processes ODBC function calls, submits SQL requests to a specific data source, and returns results to the application
• Data source, which consists of the data to access and its associated operating system, DBMS, and network platform (if any) used to access the DBMS

The following figure shows the relationship among the four components: