Comparative advantages and disadvantages of several database connection methods

Comparative advantages and disadvantages of several database connection methods

Access interface	Ease of Use	Operational capability	Scalability	Technical level	Outstanding Features
Odbc	Poor	Higher	Poor	Underlying	Lower level control possible
MFC ODBC	Good		So so	Senior	Common use standards, widely used
MFC DAO	Good	Higher	So so	Senior	Best access to Jet performance
OLE DB	Hard	High	Good	Underlying	Access to non-relational databases
Ado	Best	High	Good	Underlying	Access to non-relational databases with multiple programming interfaces

ODBC is a low-level access technology, so the ODBC API can be a client application from the underlying settings and control of the database, some advanced database technology can not be completed, but the shortcomings of ODBC can only be used in relational databases, Makes it difficult to access object databases and other non-relational databases with ODBC.

DAO provides a mechanism for creating and manipulating databases through program code. The most significant feature is the ease of operation of the Microsoft Jet database and one of the best performing technology interfaces when working with Jet databases. And it is not only used to access this kind of database, in fact, through DAO technology can access from text files to large back-end database and other data formats.

ADO is an OLE DB-based provider that is an object-oriented OLE DB technology that inherits the benefits of OLE DB. A high-level interface that belongs to database access.

Ado〉dao〉odbc in speed, comprehensive assessment Ado,odbc,dao ODBC is a relational database-based interconnect technology in Microsoft that only accesses relational databases, if programmed using SQLAPI, but with more code, if MFC ODBC-encapsulated classes are easy to access.

ADO is a COM-based database access technology, which can access relational database and non-relational database, because it is COM-based, access speed is faster and consumes less resources.

DAO is a method used by Microsoft to access the Jet engine and is primarily used to access the Access database, which is relatively simple to use.

Comparative advantages and disadvantages of several database connection methods