ODBC, OLE DB, ADO, ODAC, odp.net

faces a wide variety of data sources and access requirements. The Software development framework generally provides a unified access interface and methods to mask the underlying differences in the database. A wide variety of provider providers.


ODBC (Open database Connectivity) : A supported relational database provided by Microsoft, as well as a traditional database data type, and is only available in the C + + language API ( The API is the C language code, is the lowest-level program, in Windows is a number of. dll files in the form of services.


ole-db : Defines a unified COM interface as a standard for accessing various heterogeneous data sources and encapsulated within a set of COM objects. On the basis of support for ODBC, there are paths for other non-SQL data types.


ADO (ActiveX Data Objects) : is a COM component that is used to access data sources. It provides a programming language and uniform data access for an intermediate layer of OLE DB.


ADO : The data provider that is used first in the NET programming environment. Mainly includes: Connection class, Command object, DataReader class, DataAdapter class, DataTable class, DataSet object.


ODAC (Oracle Data Access components) : Oracle for Borland delphi,c++ Builder and Kylix provides a number of non-visual components. The

Odac directly uses the Oracle call Interface (OCI). OCI is a process or function that allows application developers to access an Oracle data server using a third-party development language, and an application interface (API) that controls the execution state of all SQL statements. OCI is through a dynamic runtime library (ora*. DLL) provides a standard database access library and functions to establish a connection in the application. You can also use the ODAC net option without having to install an Oracle client on the client computer to connect to Oracle. In this case, ODAC only needs the support of the TCP/IP protocol to create a true, minimal database application. ODAC contains the odp.net.

ODP. NET (Oracle Data Provider for. NET): A. NET use of the Oracle database's class library by Oracle Corporation for. NET developers.

Because Microsoft will deprecated System.Data.OracleClient.dll in. NET Framework4, and in terms of access efficiency and speed, System.Data.OracleClient.dll and Oracle.DataAccess.dll compared to the fact that Microsoft does not have the advantage of the class library provided by Oracle, so it has abandoned the use of System.Data.OracleClient.dll for many years and replaced it with Odp.net.

ODBC, OLE DB, ADO, ODAC, odp.net