Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many
different data sources. The application's source code does not have to be
recompiled for each data source. A database driver links the application to a specific
data source. A database driver is a dynamic-link library that an application
can invoke on demand to gain access to a particular data source. Therefore, the
application can access any data source for which a database driver exists.
The ODBC interface defines the following:
A library of ODBC function calls that allows an application to connect to a
data source, execute SQL statements, and retrieve results.
SQL syntax based on the SQL-99 specification.
A standard set of error codes.
A standard way to connect to and log in to a data source.
A standard representation for data types.
The following figure describes the components of the ODBC model.
See Also:For All Users
Bookmark
What Is ODBC?
See Also: For All Users
