ODBC (Open Info Foundation Connectivity) is actually a functionality library which supplies a standard API (Application Programming 꽁머니 Interface) for ODBC compliant database management units.
ODBC was designed by the SQL Accessibility Team in 1992.
ODBC operates as an industry-regular “shim” between apps which make the most of databases and also the databases on their own.
If an application is developed employing ODBC, the applying should be able to keep facts in almost any database administration system which is provided using an ODBC driver.
ODBC motorists are sometimes made in sub-elements:
An ODBC Driver Manager
ODBC Drivers
The applying submits ODBC phone calls towards the ODBC driver manager.
The ODBC driver supervisor selects the appropriate ODBC driver, hundreds that driver, and sends study or generate requests employing that driver.
The ODBC driver procedures the ODBC functionality phone calls, submits the SQL requests to the databases, and returns the final results to the appliance.