ODBC (Open Data Base Connectivity) is a function library which provides a common API (Application Programming Interface) for ODBC compliant database management systems. ODBC was developed by the SQL Access Group in 1992. ODBC operates as an industry-standard "shim" between applications which utilize databases and the databases themselves. If an application is developed using ODBC, the application will be able to store data in any database management system which is equipped with an ODBC driver. ODBC drivers are often developed in sub-components: • An ODBC Driver Manager • ODBC Drivers The application submits ODBC calls to the ODBC driver manager. The ODBC driver manager selects the appropriate ODBC driver, loads that driver, and sends read or write requests using that driver. The ODBC driver processes the ODBC function calls, submits the SQL requests to the database, and returns the results to the application.
About the Author:
Andy Blake writes on topics such as ODBC , Database and Relational Database for The Tech FAQ.
Wed, 09 Jul 2008 06:35:31 - 100%
Article Source: Find Articles - Reprint Rights feel free to publish this article on your website but you must agree to leave all active links contained within 'About The Author' intact and "as is" and NOT hidden behind a java or redirect script.