ODBC

From LIMSWiki
Jump to: navigation, search

ODBC (Open Database Connectivity) is a Microsoft-created application programming interface (API) for "accessing data in a heterogeneous environment of relational and non-relational database management systems (DBMS)."[1] By extension, an ODBC-compliant database is one that uses ODBC to enable exchange information with other relational and non-relational databases. An ODBC client connects with other DBMSs through a driver, which exists for most DBMSs, including Oracle, PostgreSQL, MySQL, Microsoft SQL Server (except CE edition), Sybase ASE, and DB2.[2][3][1]

References

  1. 1.0 1.1 "ODBC--Open Database Connectivity Overview". Microsoft. 02 July 2010. http://support.microsoft.com/kb/110093. Retrieved 02 March 2012. 
  2. "Introduction to ODBC". Sybase. http://infocenter.sybase.com/help/topic/com.sybase.help.sdk_12.5.1.aseodbc/html/aseodbc/Odbcpgm.htm. Retrieved 02 March 2012. 
  3. "ODBC Overview". Microsoft. http://msdn.microsoft.com/en-us/library/windows/desktop/ms710220(v=vs.85).aspx. Retrieved 02 March 2012.