ActiveX Data Objects: Difference between revisions

Revision as of 19:47, 21 August 2020

Latest revision as of 17:10, 23 June 2025

(9 intermediate revisions by 9 users not shown)

Line 3:

{{Use American English|date=January 2019}}

{{no footnotes|date=February 2013}}

In [[computing]], [[Microsoft]]'s '''ActiveX Data Objects''' ('''ADO''') comprises a set of [[Component Object Model]] (COM) [[object (computing)|object]]s for accessing data sources. A part of [[Microsoft Data Access Components|MDAC]] (Microsoft Data Access Components), it provides a [[middleware]] layer between [[programming language]]s and [[OLE DB]] (a means of accessing data stores, whether [[database]]s or not, in a uniform manner). ADO allows a [[software developer|developer]] to write programs that access data without knowing how the database is implemented; developers must be aware of the database for connection only. No knowledge of [[SQL]] is required to access a database when using ADO, although one can use ADO to execute SQL commands directly (with the disadvantage of introducing a dependency upon the type of database used).

Microsoft introduced ADO in October 1996, positioning the software as a successor to Microsoft's earlier object layers for accessing data sources, including [[Remote Data Objects|RDO]] (Remote Data Objects) and [[Jet Data Access Objects|DAO]] (Data Access Objects).

Line 68:

=== ASP example ===

Here is an [[Active Server Pages|ASP]] example using ADO to select the "Name" field, from a table called "Phonebook", where a "PhoneNumber" was equal to "555-5555".

<syntaxhighlight lang=vb"vbscript">

dim myconnection, myrecordset, name

set myconnection = server.createobject("ADODB.Connection")

Line 86:

This is equivalent to the following ASP code, which uses plain SQL instead of the functionality of the Recordset object:

<syntaxhighlight lang=vb"vbscript">

dim myconnection, myrecordset, name

set myconnection = server.createobject("ADODB.connection")

Line 95:

==Software support==

ADO is supported in any development language that supports binding to binary COM interfaces. These languages include ASP, [[Embarcadero Delphi |(programming language)|Delphi]], [[PowerBuilder]], and [[Visual Basic for Applications]] (VBA). ADO support has now been added to [[dBase]] Plus 8 (With ADO)

==Legacy==

Line 103:

* [[ADO.NET]]

* [[Comparison of ADO and ADO.NET]]

* [[ActiveX]]

* [[MSDAIPP]]

==References==

Line 109 ⟶ 111:

==External links==

* [http://msdn2.microsoft.com/en-us/library/ms805098.aspx Microsoft ADO page]

* [http://www.connectionstrings.com/ Database connection strings] {{Webarchive|url=https://web.archive.org/web/20210126200223/https://www.connectionstrings.com/ |date=January 26, 2021 }}

* [http://www.devguru.com/content/technologies/ado/home.html DevGuru ADO Quick Reference]

{{Microsoft APIs}}

{{Authority control}}

{{DEFAULTSORT:Activex Data Objects}}