Difference between revisions of "ODBC"

From LIMSWiki
Jump to navigationJump to search
(Added cat.)
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:Regulatory information]]
[[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