ODBC is a standard access to databases developed by SQL Access Group in 1992, the goal of ODBC is to make it possible to access any data from any application, regardless of what Manager System Database ( DBMS for its acronym in English ) store the data, ODBC achieves this by inserting an intermediate layer (CLI) called SQL Client Interface level, between the application and the DBMS , the purpose of this layer is to translate the application’s data queries into commands that the DBMS in shop. For this to work both the application and the DBMSthey must be ODBC compliant , that is, the application must be able to produce ODBC commands and the DBMS must be able to respond to them. Since version 2.0 the standard supports SAG and SQL .
The software works in two ways, with driver software on the client, or a client-server philosophy. In the first mode, the driver interprets the SQL connections and calls and translates them from the ODBC API to the DBMS. In the second way to connect to the Database, a DSN is created within the ODBC that defines the parameters, route and characteristics of the connection according to the data requested by the manufacturer.
It is a derivative inspired by it, the acronym for Java Database Connectivity , an API that allows the execution of operations on databases from the Java Programming Language regardless of the operating system where it is executed or the database to which it is run. accessed using the SQL dialect of the database model being used.