Home » Full Forms » Computer Acronyms/Abbreviations

What is the full form of ADO?

Full form of ADO: Here, we are going to learn what does ADO stands for? ADO – which is an abbreviation of "ActiveX Data Objects" in Computer Acronyms/Abbreviations, etc.
Submitted by Anushree Goswami, on March 19, 2020

ADO: ActiveX Data Objects

ADO is an abbreviation of "ActiveX Data Objects".

Microsoft's ActiveX Data Objects (ADO) consists of an order of sequence of Component Object Model (COM) objects for accessing sources of data in computing. A division of MDAC (Microsoft Data Access Components), it makes available a middleware layer among programming languages and OLE DB, which is a way of accessing data stores, whether databases or not, in a standardized approach. ADO enables a developer to write programs that access data devoid of understanding how the database is put into operation; developers required to be conscious of the database for association simply. No information, data, and facts of SQL are necessary to access a database when using ADO, even if one can use ADO to implement SQL commands straightforwardly with the drawback of bringing in dependency upon the category of the database used.

In October 1996, Microsoft launched ADO, placing the arrangement of software as a descendant to Microsoft's former object layers for accessing sources of data, comprising RDO (Remote Data Objects) and DAO (Data Access Objects).

ADO is manufactured by the combination of four collections and twelve objects.

ADO Collections

• Fields:
  This collection includes an order of arrangement of Field objects. The Collection of field objects can be used in either a Recordset object or in a Record object.
• Properties:
  An object can have more than one Property object, which is included in the object's Properties collection.
• Parameters:
  A Command object can have quite a lot of Parameter commands to modify its predefined performance, and each of the Parameter objects is included in the Command object's Parameters collection.
• Errors:
  All provider-created errors are passed to a collection of Error objects, at the same time as the Errors collection itself is included in a Connection object.

ADO Fundamental Usage

A variety of fundamental steps are necessary in order to be able to access and control data using ADO, which comprise:

• Build a connection object to make a connection to the database.
• Build a recordset object to take delivery of data.
• Open the connection
• Occupy the record set by opening it and passing the preferred table name or SQL statement as a factor to open function.
• Perform all the preferred searching/processing on the extracted data.
• Carry out the changes as a user-made to the data (if any) by using Update or
• Update Batch techniques.
• Close the recordset
• Secure and close up the connection

Supported software

• ADO is supported in any advance language that supports binding to binary COM interfaces.
• These languages consist of ASP, Delphi, PowerBuilder, and Visual Basic for Applications (VBA).
• ADO support has now been supplemented to dBase Plus 8 (With ADO).