ODBC Interface

ODBC is a Microsoft standard. You can obtain documentation for this interface from Microsoft. ODBC version 3.0 is based on the ANSI SQL language standard (SQL 92).

ODBC provides:

The ability to develop applications that are independent of the database
Open access to databases in a unified way

An system build on the ODBC interface should theoretically be able to work with other different SQL servers. This is not practical since dialects of the SQL language and the way individual SQL servers operate vary greatly.

ODBC Driver

The module that transfers application requests to the SQL server, is called an ODBC driver. You must install this driver on the computer that will run the application. The ODBC Driver Manager is a system library for running ODBC drivers that also must be installed on the computer.

ODBC drivers can be obtained from the database server manufacturer. An ODBC driver for the 602SQL Server is both available for Windows and Linux. It is included in the basic installation.

ODBC Data Source

A data set accessible through ODBC is called a data source. The database is not a data source in 602SQL, but the scheme is. If you need to access data from more schemes, you must create more data sources.

602SQL as an ODBC Client

The 602SQL client interface since version 9.5 may serve as a client for other databases, that use an ODBC driver and are properly registered in the operating system (Windows or Linux). You can find more information in the 602SQL client interface as an ODBC client chapter.

List of topics:

602SQL as an ODBC Server

Interfaces for the 602SQL Server

SDBC Interface