This figure shows an ODBC application accessing three separate databases. 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). The following figure shows the components of the ODBC model.

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. 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.

Change odbc timeout