ODBC (Open up Data Foundation Connectivity) is often a functionality library which delivers a standard API (Application Programming Interface) for ODBC compliant databases management programs.
ODBC was formulated through the SQL Entry Group in 1992.
ODBC operates as an sector-typical “shim” concerning apps which use databases as well as databases by themselves.
If an application is created applying ODBC, the appliance should be able to keep knowledge in any databases management program which is supplied by having an ODBC driver.
ODBC motorists are often created in sub-factors:
An ODBC Driver Supervisor
ODBC Drivers
The applying submits ODBC calls into the ODBC driver manager.
The ODBC driver supervisor selects the appropriate ODBC driver, hundreds that driver, and sends read through or write requests employing that driver.
The ODBC driver procedures the ODBC 꽁머니 purpose phone calls, submits the SQL requests into the databases, and returns the outcome to the appliance.