JDBC, ODBC, OLE DB, ADO, ADOMD differences and connections

ODBC: (Open Database Connectivity), which establishes a set of specifications and provides a set of standard APIs (application programming interfaces) for database access. These APIs use SQL to accomplish most of their tasks. ODBC itself also provides support for the SQL language, which allows users to send SQL statements directly to ODBC.

JDBC: All called Java DataBase Connectivity Standard, an object-oriented application interface (API) that allows you to access a variety of relational databases. JDBC is also part of the Java Core Class library.

OLE DB (object link and embed are objects connected and embedded. ) is Microsoft's strategic low-level application interface to different data sources. OLE DB includes not only the structured Problem language (SQL) capability of the Microsoft-funded standard data Interface Open Database Connectivity (ODBC), but also the pathways for other non-SQL data types.

The difference between OLE DB and ODBC

Since OLE DB and ODBC standards are all designed to provide a unified access data interface, there was a confusion: is it a new standard for ODBC? The answer is in the negative. In fact, the ODBC standard object is a SQL-based data source (sql-based), whereas OLE DB objects are any data store of a wider scope. In this sense, ODBC-compliant data sources are subsets of data stores that conform to OLE DB standards.

ADO: Microsoft's ADO (ActiveX data Objects) is a COM component used to access data sources. Microsoft encapsulates ole-db as an ADO object in COM technology, which provides a programming language and a middle tier of OLE DB for unified data access. Allows developers to write code that accesses data without worrying about how the database is implemented, but only the connections that are concerned with the database.

Speaking of the popular Point OLE DB and ODBC are the lowest things, and the ADO object provides us with a "visualization" of components that interact directly with the application layer.

ADOMD: ADO specifically for cubes.

JDBC, ODBC, OLE DB, ADO, ADOMD differences and connections