ODBC (Open Information Foundation Connectivity) is really a purpose library which presents a common API (Software Programming Interface) for ODBC compliant database administration systems.
ODBC was developed through the SQL Entry Team in 1992.
ODBC operates being an field-regular “shim” concerning applications which utilize databases as well as the databases them selves.
If an software is made making use of ODBC, the applying can retailer knowledge in almost any databases administration procedure which is supplied using an 꽁머니 ODBC driver.
ODBC drivers tend to be developed in sub-components:
An ODBC Driver Manager
ODBC Drivers
The appliance submits ODBC phone calls to the ODBC driver supervisor.
The ODBC driver supervisor selects the appropriate ODBC driver, loads that driver, and sends go through or generate requests making use of that driver.
The ODBC driver processes the ODBC operate calls, submits the SQL requests into the database, and returns the effects to the appliance.