

Odbc manager driver#
The ODBC Driver accesses the database over a network communications link using the database API. Still using the ODBC API, the Driver Manager makes a call to the ODBC Driver. The Driver Manager can be either the Microsoft Driver Manager or the unixODBC Driver Manager.

The model begins with an ODBC application making a call to the Driver Manager through the ODBC application program interface (API). SQL syntax based on the SQL-99 specification.Ī standard way to connect to and log in to a data source.Ī standard representation for data types.įigure 24-1 shows the components of the ODBC model. The ODBC interface defines the following:Ī library of ODBC function calls that allows an application to connect to a data source, execute structured query language (SQL) statements, and retrieve results. Therefore, the application can access any data source for which a database driver exists. A database driver is a dynamic-link library that an application can invoke on demand to gain access to a particular data source. A database driver links the application to a specific data source.

The application's source code does not have to be recompiled for each data source. Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many different data sources.
