Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
ADO consists of the following nine objects and four collections.
| Object or Collection | Description |
|---|---|
| Connection object | Represents a unique session with a data source. In the case of a client/server database system, it may be equivalent to an actual network connection to the server. Depending on the functionality supported by the provider, some collections, methods, or properties of a Connection object may not be available. |
| Command object | Used to define a specific command, such as a SQL query, intended to run against a data source. |
| Recordset object | Represents the entire set of records from a base table or the results of an executed command. All Recordset objects consist of records (rows) and fields (columns). |
| Record object | Represents a single row of data, either from a Recordset or from the provider. This record could represent a database record or some other type of object such as a file or directory, depending upon your provider. |
| Stream object | Represents a stream of binary or text data. For example, an XML document can be loaded into a stream for command input or returned from certain providers as the results of a query. A Stream object can be used to manipulate fields or records containing these streams of data. |
| Parameter object | Represents a parameter or argument associated with a Command object, based on a parameterized query or stored procedure. |
| Field object | Represents a column of data with a common data type. Each Field object corresponds to a column in the Recordset. |
| Property object | Represents a characteristic of an ADO object that is defined by the provider. ADO objects have two types of properties: built-in and dynamic. Built-in properties are those properties implemented in ADO and immediately available to any new object. The Property object is a container for dynamic properties, defined by the underlying provider. |
| Error object | Contains details about data access errors that pertain to a single operation involving the provider. |
| Fields collection | Contains all the Field objects of a Recordset or Record object. |
| Properties collection | Contains all the Property objects for a specific instance of an object. |
| Parameters collection | Contains all the Parameter objects of a Command object. |
| Errors collection | Contains all the Error objects created in response to a single provider-related failure. |