ActiveX Data Objects: Difference between revisions

Revision as of 16:11, 18 July 2006

Revision as of 18:42, 8 August 2006

Line 1:

Microsoft '''ActiveX Data Objects''' (ADO) is a set of [[Component Object Model]] objects for accessing data sources. It provides a layer between [[programming language]]s and [[OLE DB]] (a means of accessing data stores, whether they be [[database]]s or otherwise, in a uniform manner), which allows a developer to write programs which access data, without knowing how the database is implemented. You must be aware of your database for connection only. No knowledge of [[SQL]] is required to access a database when using ADO, although one can use ADO to execute arbitrary SQL commands. The disadvantage of this (i.e. using SQL directly) is that thisit introduces a dependency upon the type of database used.

It is positioned as a successor to Microsoft's earlier object layers for accessing data sources, including [[Remote Data Objects|RDO]] (Remote Data Objects) and [[Data Access Objects|DAO]] (Data Access Objects). ADO was introduced by [[Microsoft]] in the winter of [[1996]].