Open Database Connectivity

Open Database Connectivity (ODBC) is a standard software API for connecting to database management systems (DBMS). This API is independent of any one programming language, database system or operating system. ODBC is based on the Call Level Interface (CLI) specifications from SQL, X/Open (now part of The Open Group), and the ISO/IEC. ODBC was created by the SQL Access Group and first released in September, 1992.

ODBC is a native interface that is accessed through a language that can make calls into a native library. In case of the Windows platform, this library is a DLL. Microsoft Windows was the first to provide an ODBC product. Now versions exist for UNIX, OS/2, and Macintosh platforms as well.

In addition to the ODBC software, a separate module or driver is needed for each database to be accessed. The functions in the ODBC API are implemented by these DBMS-specific drivers. ODBC allows programs to use SQL requests that will access databases without having to know the proprietary interfaces to the databases. It handles the SQL request and converts it into a request the individual database system understands.

Most current DBMSs support ODBC which means that computer programs that rely on ODBC can connect to several different brands of DBMSs using the same basic code.

A JDBC-ODBC Bridge is a JDBC driver which employs the ODBC driver to connect to the database. This driver translates JDBC method calls into ODBC function calls. The bridge is usually used when there is no JDBC driver available for a particular database.

UnixODBC is the standard for ODBC on non MS Windows platforms. This is to include XFree86 GUI support for both GNOME and KDE. UnixODBC is used by OpenOffice.

External links

Microsoft ODBC Documentation (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/dasdkodbcoverview.asp)
Presentation slides from www.roth.net (http://www.roth.net/perl/odbc/conf/sld002.htm)
http://www.odbc.org/

de:ODBC es:ODBC fr:Open database connectivity ja:Open Database Connectivity

Retrieved from "http://www.mywiseowl.com/articles/Open_Database_Connectivity"

This page has been accessed 351 times. This page was last modified 20:04, 16 Nov 2004. All text is available under the terms of the GNU Free Documentation License (see Copyrights for details).