ODBC (Open up Facts Base Connectivity) is a perform library which provides a common API (Software Programming Interface) for ODBC compliant databases administration units.
ODBC was formulated from the SQL Obtain Team in 1992.
ODBC operates as an sector-normal “shim” in between apps which make use of databases plus the databases on their own.
If an application is designed applying ODBC, the application can shop knowledge in any databases administration process which is equipped with the ODBC driver.
ODBC motorists will often be made in sub-elements:
An ODBC Driver Manager
ODBC Motorists
The applying submits ODBC phone calls to the ODBC driver supervisor.
The ODBC driver manager 꽁머니 selects the right ODBC driver, hundreds that driver, and sends browse or publish requests working with that driver.
The ODBC driver processes the ODBC functionality phone calls, submits the SQL requests to the database, and returns the effects to the appliance.