ODBC

From Simple Wiki
Revision as of 15:27, 16 January 2022 by Aaron (talk | contribs) (Created page with "ODBC stands for [https://en.wikipedia.org/wiki/Open_Database_Connectivity Open DataBase Connectivity] and is a common driver standard to allow applications to communicate with...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

ODBC stands for Open DataBase Connectivity and is a common driver standard to allow applications to communicate with various databases independent of the type of database.

The most popular databases, like Access, SQL Server, Oracle and MySQL can all connect directly via OleDB without the use of an ODBC data source.

ODBC can be used to connect to less commonly used formats, including Excel files, IBM DB/2 and some proprietary databases.