Open DataBase Connectivity

(redirected from ODBC driver)

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].

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.
References in periodicals archive ?
In addition to serving up relational tables through InterSystems ODBC driver, Power BI users now can also access InterSystems IRIS business intelligence (BI) cubes, leveraging the measures and dimensions defined in the data platform.
Now ODBC driver for BigCommerce supports OAuth authentication.
BlueBay chose to work with the Progress DataDirect OpenAccess SDK to build a custom ODBC driver that enabled seamless integration with Tableau, while still leveraging the database customizations important to their business.
- Secure connectivity to Oracle EBS data through users' existing accounts via the Noetix ODBC driver.
QuickBooks Enterprise includes the ODBC driver necessary to create these ODBC queries for free, and for a fee of $149, the required ODBC driver can also be added to QuickBooks Premier at qodbc.com.
As part of a joint technology investment, the latest version of Tableau software includes Splunk Enterprise as a native data source using Splunk's recently launched ODBC driver.
The ODBC driver is part of a collection of U2 Clients that supplies the gateways for other systems to interact with the U2 databases.
The new release offers the following enhancements: omni-dimensional analysis; as-of linking; row expansion; a new ODBC driver; as well as a new software development kit for connecting to 1010data.
Some of the chapters look at the ways that information stored in SAS data sets can be viewed using applications other than SAS, such as SAS ODBC driver, SAS Integration Technologies, and with graphical report files from SAS/GRAPH programs.
In addition, the ODBC driver for Shadow(R) Direct v.4.8 has successfully passed internal testing to support Microsoft's .NET framework and Visual Studio.NET.
But with an ODBC driver it can produce reports from other databases on other platforms.