ODBC (Open Data Foundation Connectivity) is usually a functionality library which gives a typical API (Application Programming Interface) for ODBC compliant databases management programs.
ODBC was created through the SQL Accessibility Group in 1992.
ODBC operates being an field-normal “shim” amongst programs which utilize databases along with the databases by themselves.
If an software is designed making use of ODBC, the applying should be able to retailer details in almost any database administration method which is supplied by having an ODBC driver.
ODBC drivers will often be created in sub-components:
An ODBC Driver Manager
ODBC Motorists
The appliance submits ODBC calls towards the 꽁머니 ODBC driver manager.
The ODBC driver manager selects the right ODBC driver, loads that driver, and sends read or compose requests utilizing that driver.
The ODBC driver procedures the ODBC function calls, submits the SQL requests for the database, and returns the results to the appliance.