Open Database Connectivity: Difference between revisions

Content deleted Content added
m unlinked acronym to disambig page
m space, rephrase, wikilink, org. lang. links
Line 1:
'''Open Database Connectivity''' or '''ODBC''' is a standard [[software]] [[API]] for connecting to [[database management system]]s (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 [[Microsoft Windows|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 [[Apple Macintosh|Macintosh]] platforms as well.
 
In addition to the ODBC software, a separate module or [[Database driver|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 databasecurrent management systems (DBMSs) nowadays support ODBC which means that [[Computer program|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.
 
==External linklinks==
*[http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcstartpage1.asp Microsoft ODBC Documentation]
*[http://www.roth.net/perl/odbc/conf/sld002.htm Presentation slides from www.roth.net]
 
[[de:ODBC]]
[[es:ODBC]]
[[fr:ODBC]]
[[de:ODBC]]
[[ja:ODBC]]