ALERT

[WEBINAR] Building a Business-Driven Data Architecture

ActiveX Data Objects (ADO)

Definition - What does ActiveX Data Objects (ADO) mean?

ActiveX Data Objects (ADO) is a collection of software components providing a programmatic interface to access the data sources from client applications. ADO acts as a layer to access any data store in a generic way from the application code. It eliminates the need to possess the knowledge of database implementation and reduces the complexity of dealing with the low level code needed to handle the data.

Released in 1996, activeX data object (ADO) originated from the concept of RDO (remote data object) and DAO (data access object). One of the constituents of MDAC (Microsoft data access components), ADO and other MDAC constituents provides a framework of components used by client applications to access SQL, semi-structured and legacy data stores.

ADO.NET is an advanced data access technology designed to work in the .NET environment and is based on the disconnected model for data access. While ADO uses COM (Component Object Model) technology for providing data access service from unmanaged code, ADO.NET depends on managed providers of the CLR (Common Language Runtime) of the .NET framework.

Techopedia explains ActiveX Data Objects (ADO)

ADO uses an OLEDB provider for connecting to the data sources and accessing data. OLEDB is a component based programmatic interface provided to interact with different data sources. These data sources can be both relational and non-relational databases such as object databases, web pages, spreadsheets or e-mail messages. Prior to OLEDB and ADO, ODBC (open database connectivity) was the popular model used in applications across platforms.

The object model of ADO contains four collections of twelve objects. The different collections are fields, properties, parameters and errors. Each collection consists of the following twelve objects:

  1. Connection - for connecting to data source through OLE DB
  2. Command - for sending an instruction (SQL query or stored procedure) to data provider
  3. Recordset - a group of records representing the data
  4. Immediate - a recordset locked in optimistic or pessimistic way
  5. Batch - for committing or doing a rollback database transaction
  6. Transaction - the database transaction
  7. Record - a set of fields
  8. Stream - for reading and writing a stream of bytes
  9. Parameter - for changing the functionality
  10. Field - a column in the database
  11. Property - the ability of OLEDB provider
  12. Error - the error faced by the OLEDB provider during its execution

ADO 2.8 is the latest version and has the following features:

  • Components: These are used for data access and manipulation from a variety of sources to offer benefits like ease of use, faster access, low memory overhead and a small disk footprint.
  • ADO MD (MultiDImensional): This is used to access multidimensional data like CubeDef and CellSet objects.
  • RDS (Remote Data Services): This is for retrieval and update of data in the server from a client in a single transaction.
  • ADOX (ADO Extensions): This is an additional set of components used to create and maintain objects related to schema (tables or procedures) and security (user and group).

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.