Saturday, April 4, 2009

All About ODBC

ODBC (Open Data Base Connectivity) is a action library which provides a accepted API (Application Programming Interface) for ODBC adjustable database administration systems.

ODBC was developed by the SQL Access Group in 1992.

ODBC operates as an industry-standard "shim" amid applications which advance databases and the databases themselves.

If an appliance is developed appliance ODBC, the appliance will be able to abundance abstracts in any database administration arrangement which is able with an ODBC driver.


ODBC drivers are generally developed in sub-components:

• An ODBC Disciplinarian Administrator

• ODBC Drivers

The appliance submits ODBC calls to the ODBC disciplinarian manager.

The ODBC disciplinarian administrator selects the adapted ODBC driver, endless that driver, and sends apprehend or address requests appliance that driver.

The ODBC disciplinarian processes the ODBC action calls, submits the SQL requests to the database, and allotment the after-effects to the application.

0 comments: