Open DataBase Connectivity


Also found in: Acronyms, Wikipedia.

Open DataBase Connectivity

(standard, database)
(ODBC) A standard for accessing different database systems. There are interfaces for Visual Basic, Visual C++, SQL and the ODBC driver pack contains drivers for the Access, Paradox, dBase, Text, Excel and Btrieve databases.

An application can submit statements to ODBC using the ODBC flavor of SQL. ODBC then translates these to whatever flavor the database understands.

ODBC 1.0 was released in September 1992.

ODBC is based on Call-Level Interface and was defined by the SQL Access Group. Microsoft was one member of the group and was the first company to release a commercial product based on its work (under Microsoft Windows) but ODBC is not a Microsoft standard (as many people believe).

ODBC drivers and development tools are available now for Microsoft Windows, Unix, OS/2, and Macintosh.

["Unix Review", Aug 1995].
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

ODBC

(Open DataBase Connectivity) A database programming interface from Microsoft that provides a common language for Windows applications to access databases on a network. ODBC is made up of the function calls programmers write into their applications and the ODBC drivers themselves.

For client/server database systems such as Oracle and SQL Server, the ODBC driver provides links to their database engines to access the database. For desktop database systems such as Access and FoxPro, the ODBC drivers actually manipulate the data. ODBC supports SQL and non-SQL databases. Although the application always uses SQL to communicate with ODBC, ODBC will communicate with non-SQL databases in its native language. See JDBC.


ODBC Interfaces
These are the various ways applications access data sources using ODBC and other Microsoft interfaces.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
With open database connectivity, users could see the data tables within the city's ERP system just as if they were any other table in the database.
The devoted server runs Windows 2000 Server with the Microsoft Access database queried via the Open Database Connectivity (ODBC) protocol.
Newer integration alternatives can move data in and out of applications using common industry-standard technologies such as XML (extensible markup language), ODBC (open database connectivity), and even simple delimited data files.
OSAS 7.0 also includes an Install-Shield wizard for easier installation, dozens of Excel PivotTable productivity reports, an open database connectivity (ODBC) driver, improved user tracking, shipment tracking, address mapping and much more, Open Systems says.
Open Database Connectivity (ODBC) and Object Linking and Embedding (OLE) features ensure compatibility with many popular database, word processing and graphic design programme.
Open Database Connectivity (ODBC) also enables managers to integrate data with the reporting capabilities of Crystal Reports, Microsoft Excel and other applications.
The current hosting configuration supports the use of many common web server components unique to Windows[R] web servers such as Active Server Pages (ASP), a Microsoft technology used to embed programming scripts into Hypertext Markup Language (HTML) making them interactive, and Open DataBase Connectivity (ODBC) to multiple Access databases.
Its Open Database Connectivity (ODBC) driver allows us to access the database using standard data access components such as ODBC and SQL.
* Custom interface using open database connectivity. When it's critical to have a transparent interface between two applications, users will sometimes have a custom application written that communicates directly with the databases where the information is stored.
Don't limit your lotus to paper outputs; you should also find a system that is Open Database Connectivity (ODBC) compatible, and that con export data to XML files.
Sybase PowerBuilder provides the ability to turn functionality on and off at the agency level, while the system's client/server capability utilizes Open DataBase Connectivity (ODBC) to provide a connection to the Sybase database, allowing for advanced user support through the ability to connect to various data sources.
After gathering data, we had to make the decision to try to use open database connectivity to the database or their standard messaging.