What is ODBC ?

Posted On 2011-01-22 by FortyPoundHead
Keywords:
Tags: Glossary General Tutorial 
Views: 773


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

has posted a total of 1974 articles.


Comments On This Post

No comments on this post yet!


Do you have a thought relating to this post? You can post your comment here. If you have an unrelated question, you can use the Q&A section to ask it.

Or you can drop a note to the administrators if you're not sure where you should post.


Your IP address is:54.81.71.219

Before you can post, you need to prove you are human. If you log in, this test goes away.


Code Links