ODBC (Open up Information Base Connectivity) is often a perform library which provides a common API (Software Programming Interface) for ODBC compliant databases administration techniques.
ODBC was formulated via the SQL Accessibility Group in 1992.
ODBC operates as an field-standard “shim” amongst applications which employ databases along with the databases them selves.
If an application is 꽁머니 made utilizing ODBC, the applying will be able to retail store facts in almost any database administration program which is equipped having an ODBC driver.
ODBC motorists are frequently made in sub-factors:
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 browse or generate requests employing that driver.
The ODBC driver processes the ODBC purpose phone calls, submits the SQL requests for the database, and returns the final results to the applying.