ADO

ADO

ADO - Active Data Objects

Active Data Objects are designed to replace DAO and RDO. Besides databases, they can be used to get at different data sources, in particular databases, but in general any sort of data which can be represented with rows and columns. For example Jet database, Exchange, Proxy server, Index server.

Their are several objects in the ADO programming environment:

  • ADO - Command Object - The Command object is an object used to access stored procedures or parameterized SQL statements.
  • ADO - Connection Object - The Connection object is used to open a connection to a database.
  • ADO - Error Object The Error object contains information about a single error or warning from an OLEDB provider. Error objects are contained within a 0-based Errors collection which is referenced from a Connection object.

  • Errors - The Errors object contains Error objects. It is exposed as a property off the Connection object.

  • Field - The Field object is a logical wrapper around a column in a table. The properties collection contains a collection of Property objects which hold meta information about the column.

  • Fields is a collection of database columns associated with a record in a RecordSet. The values within the Field objects within the Fields collection change as different navigational methods are used to move around the RecordSet.

  • Parameter - The Parameter object is a wrapper for a single parameter for a stored procedure or a query. Used with the Command object.

  • Parameters - Parameter objects are used to hold values which are passed to and from stored procedures. The Parameters object manages a collection of Parameter objects. You can access a Parameters collection from the ADO.Command object.

  • Properties

  • Property - Property object contains the attributes of a single property, for a Connection, Command, RecordSet, or Field object. Each object contains a Properties collection which contain 0 or more Property objects. These contain values which represents attributes not exposed by any other property of the object.

  • ADO - Record Object The ADO Record object (New with 2.5) represents things like Directories and Files in a file system, and folders and messages in an e-mail system. A record can also represent a row in a RecordSet. A record has a Field collection.

  • RecordSet manages a collection of records. It contains navigational methods to move to a particular record.

  • Stream - New with 2.5