Open Database Connectivity [ODBC] provides a
standard software API method for using database management systems
[DBMS]. ODBC operates independent of programming languages, database
systems, and operating systems.
The ODBC specification offers a procedural API for using SQL queries
to access data.
A basic implementation of ODBC on Linux includes:
- An ODBC Compliant Application - an application
which uses the ODBC API to talk to a DBMS.
- The ODBC Driver Manager - the independent
link between an ODBC application and an ODBC driver. Applications
requiring ODBC access link with the driver manager and make ODBC
API calls which cause the driver manager to load the appropriate
- A ODBC Repository - list of installed ODBC
drivers and defined ODBC data sources. The ODBC driver manager
normally looks after these definitions and consults them when
applications connect to a data source.
- An ODBC Driver - translates ODBC API calls
into something the backend DBMS understands.
ODBC also includes:
- A cursor library
- Utilities and APIs to install, remove and query installed drivers.
- APIs for data sources to be configured/created/removed from
- Utility APIs an ODBC driver can use to handle the reading and
writing of data source definitions
- A GUI and non-GUI ODBC Administrator
- All the header files required to build ODBC applications
A JDBC-ODBC bridge consists of a JDBC driver which employs the
ODBC driver to connect to the database.
This driver translates JDBC method calls into ODBC function calls.
Independent data-access vendors deliver JDBC-ODBC bridges which
support current standards for both mechanisms, and which far outperform
the JVM built-in.
An ODBC-JDBC bridge consists of an ODBC driver which uses the
services of a JDBC driver to connect to a database.
This driver translates ODBC function calls into JDBC method calls.
Programmers usually use such a bridge when they lack an ODBC driver
for a particular database but have access to a JDBC driver.
Next: Java Database Connectivity
Back To Top
The World's Leading Guide To BI Strategy, Program & Technology
Database Index | Relational
Model | Object Model | Other
Models | DBMS | Contextual
Types | Microsoft SQL | Oracle
OODBMS | Data Warehouse | Teradata
ADW | Data Mart | MS
vs Teradata | Development Platforms
| ODBC | JDBC | SMP
| MPP | SN