ODBC (Open Information Foundation Connectivity) is often a purpose library which gives a typical API (Software Programming Interface) for ODBC compliant databases administration systems.
ODBC was created via the SQL Entry Team in 1992.
ODBC operates as an business-normal “shim” concerning apps which utilize databases and the databases themselves.
If an software is formulated employing ODBC, the application will be able to store information in any databases management procedure which is supplied with an ODBC driver.
ODBC drivers in many cases are produced in sub-components:
An ODBC Driver Manager
ODBC Drivers
The application submits ODBC phone calls towards the ODBC driver supervisor.
The ODBC driver supervisor selects the right ODBC driver, loads that driver, and 꽁머니 sends study or produce requests applying that driver.
The ODBC driver processes the ODBC operate phone calls, submits the SQL requests into the database, and returns the final results to the application.