Open Database Connectivity (ODBC)

Open Database Connectivity (ODBC) - A Microsoft-developed standard for database software from different manufacturers and on different computers that enables users to share data through ODBC drivers (or translators). ODBC is defined by an international (ISO) and a national (ANSI) standard. The most recent version is called SQL-92. (There are now at least 4 different ODBC "standards", and not every software maker's implementation is fully compatible with all the others.)

[Category=Database Management ]

Source: Northwest Database Services, 12 November 2009 11:09:35, http://www.nwdatabase.com/database-glossary-o.htm

---

These advertisers support this free service

---

Open Database Connectivity (ODBC) - Open database connectivity is a standard for database access co-opted by Microsoft from the SQL Access Group consortium.

[Category=Information Management ]

Source: Information-Management.com, 30 June 2010 09:29:30, http://www.information-management.com/glossary/m.html

---

ODBC - Open Database Connectivity. A standard for database access co-opted by Microsoft from the SQL Access Group consortium.

[Category=Data Warehousing ]

Source: Sun.com, 09 August 2010 07:10:12, http://www.sun.com/third-party/dw/brochures/67198.Acrobat.pdf

---

ODBC - Open Database Connectivity. A standard for database access co-opted by Microsoft from the SQL Access Group consortium.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 21 December 2010 08:09:44, http://www.aexis.eu/DataWarehouse-Glossary/

---

ODBC - Open DataBAse Connectivity is a standard interface to databases developed by Microsoft. ODBX drivers are a middle layer between the application and the DBMS that translates the application's standard SQL queries into commands specific to that DBMS.

[Category=Data Quality ]

Stibo Systems, 25 May 2011 08:27:16, http://www.stibosystems.com/US/Resources/Glossary/F.aspx

---

ODBC - Open Database Connectivity is a protocol used to allow reporting tools, such as Cognos Impromptu, Microsoft Access or Excel or Crystal Reports to connect to a database.

[Category=Business Intelligence ]

Source: University of Toronto Business Intelligence, 25 October 2012 08:41:53, http://www.utbi.utoronto.ca/gethelp/glossary.htm  

---

Open Database Connectivity (ODBC) - Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database. By using ODBC statements in a program, you can access files in a number of different databases, including Access, dBase, DB2, Excel, and Text. In addition to the ODBC software, a separate module or driver is needed for each database to be accessed. The main proponent and supplier of ODBC programming support is Microsoft.

ODBC is based on and closely aligned with The Open Group standard Structured Query Language (SQL) Call-Level Interface. It allows programs to use SQL requests that will access databases without having to know the proprietary interfaces to the databases. ODBC handles the SQL request and converts it into a request the individual database system understands.

ODBC was created by the SQL Access Group and first released in September, 1992. Although Microsoft Windows was the first to provide an ODBC product, versions now exist for UNIX, OS/2, and Macintosh platforms as well.

In the newer distributed object architecture called Common Object Request Broker Architecture (CORBA), the Persistent Object Service (POS) is a superset of both the Call-Level Interface and ODBC. When writing programs in the Java language and using the Java Database Connectivity (JDBC) application program interface, you can use a product that includes a JDBC-ODBC "bridge" program to reach ODBC-accessible databases.

Related glossary terms: Java Online Analytical Processing (JOLAP), Java Database Connectivity (JDBC), Java Data Objects (JDO), Java Database Connectivity Connector (JDBC Connector)

[Category=Data Management ]

Source: WhatIs.com, 29 August 2013 09:04:40, http://whatis.techtarget.com/glossary/Data-and-Data-Management