The Open Database Connectivity (ODBC) interface allows applications to access data from database management systems (DBMS), using Structured Query Language (SQL) expressions. The processing required by the application is essentially independent of the DBMS.
The application and the driver programs that access the DBMS are physically separate. To access a DBMS, you need only ensure a driver for that DBMS is available. There are ODBC drivers for virtually all commercial DBMS. Note that the DBMS need not itself support SQL, for example dBase does not. All that matters is that the ODBC DBMS driver is available. An ODBC DBMS driver, together with information on where its datasets are stored, is typically referred to as a data source.
The J/ODBC interface uses the Data Driver verbs defined in script dd.ijs. The application sends requests to the Data Driver, which converts them into a standard format and sends them to the ODBC Manager. The ODBC Manager then sends them to the appropriate Data Source, and is also responsible for ensuring the required drivers are loaded. The Data Source drivers then handle the data access.
Explore - user documentation, see also the top navigation bar
Data Sources - data sources
Handles - connection and statement handles
Error Messages - error messages
Programming Interface:
Connect - connecting to a database
Read - reading data
Update - updating data
Create - creating a table
See also
There are several ODBC labs in the J system.