ODBC

From J Wiki
Jump to navigation Jump to search
ODBC: Data Sources | Handles | Data Driver | Error Messages | API: Connect Read Update Create Bulk Insert Config

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

Programming Interface:



See also

There are several ODBC labs in the J system.