Difference between revisions of "ODBC"
From LIMSWiki
Jump to navigationJump to searchShawndouglas (talk | contribs) (Added cat.) |
Shawndouglas (talk | contribs) m (Updated cat) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
'''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)."<ref name=MSODBC>{{cite web |url=http://support.microsoft.com/kb/110093 |title=ODBC--Open Database Connectivity Overview |publisher=Microsoft |date=02 July 2010 |accessdate=02 March 2012}}</ref> 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.<ref>{{cite web |title=Introduction to ODBC |url=http://infocenter.sybase.com/help/topic/com.sybase.help.sdk_12.5.1.aseodbc/html/aseodbc/Odbcpgm.htm |publisher=Sybase |accessdate=02 March 2012}}</ref><ref>{{cite web |url=http://msdn.microsoft.com/en-us/library/windows/desktop/ms710220(v=vs.85).aspx |title=ODBC Overview |publisher=Microsoft |accessdate=02 March 2012}}</ref><ref name=MSODBC /> | '''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)."<ref name=MSODBC>{{cite web |url=http://support.microsoft.com/kb/110093 |title=ODBC--Open Database Connectivity Overview |publisher=Microsoft |date=02 July 2010 |accessdate=02 March 2012}}</ref> 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.<ref>{{cite web |title=Introduction to ODBC |url=http://infocenter.sybase.com/help/topic/com.sybase.help.sdk_12.5.1.aseodbc/html/aseodbc/Odbcpgm.htm |publisher=Sybase |accessdate=02 March 2012}}</ref><ref>{{cite web |url=http://msdn.microsoft.com/en-us/library/windows/desktop/ms710220(v=vs.85).aspx |title=ODBC Overview |publisher=Microsoft |accessdate=02 March 2012}}</ref><ref name=MSODBC /> | ||
==References== | ==References== | ||
| Line 5: | Line 5: | ||
<!---Place all category tags here--> | <!---Place all category tags here--> | ||
[[Category: | [[Category:Software and hardware terms]] | ||
Latest revision as of 16:27, 22 August 2014
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.0 1.1 "ODBC--Open Database Connectivity Overview". Microsoft. 2 July 2010. http://support.microsoft.com/kb/110093. Retrieved 02 March 2012.
- ↑ "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.
- ↑ "ODBC Overview". Microsoft. http://msdn.microsoft.com/en-us/library/windows/desktop/ms710220(v=vs.85).aspx. Retrieved 02 March 2012.
