Overview of OLE DB, ADO, and ODBC
OLE DB is a system level interface that uses COM to provide access to many sorts of data including relational and non-relational formats. It is possible to write code that directly interfaces with the OLE DB layer; although with ADO, it's much more complex and in most cases, unnecessary.
Many OLE DB providers are implementations of the OLE DB interfaces for providing access to specific vendor data. For instance, some OLE DB providers give access to data from Paradox, Oracle, Microsoft SQL Server, the Microsoft Jet Engine, and ODBC just to name a few.
ADO is the application level interface that developers use to access data. Whereas OLE DB consists of many (more than 60) different interfaces, ADO only consists ...
Get Borland® Delphi™ 6 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
