Overview of ADO Components
Go Up to Working with ADO Components Index
The ADO page of the Tool palette hosts the dbGo components. These components let you connect to an ADO data store, execute commands, and retrieve data from tables in databases using the ADO framework. They require ADO 2.1 (or higher) to be installed on the host computer. Additionally, client software for the target database system (such as Microsoft SQL Server) must be installed, as well as an OLE DB driver or ODBC driver specific to the particular database system.
Most dbGo components have direct counterparts in the components available for other data access mechanisms: a database connection component (TADOConnection) and various types of datasets. In addition, dbGo includes TADOCommand, a simple component that is not a dataset but which represents an SQL command to be executed on the ADO data store.
The following table lists the ADO components.
ADO components:
| Component | Use |
|---|---|
|
A database connection component that establishes a connection with an ADO data store; multiple ADO dataset and command components can share this connection to execute commands, retrieve data, and operate on metadata. | |
|
The primary dataset for retrieving and operating on data; TADODataSet can retrieve data from a single or multiple tables; can connect directly to a data store or use a TADOConnection component. | |
|
A table-type dataset for retrieving and operating on a recordset produced by a single database table; TADOTable can connect directly to a data store or use a TADOConnection component. | |
|
A query-type dataset for retrieving and operating on a recordset produced by a valid SQL statement; TADOQuery can also execute data definition language (DDL) SQL statements. It can connect directly to a data store or use a TADOConnection component | |
|
A stored procedure-type dataset for executing stored procedures; TADOStoredProc executes stored procedures that may or may not retrieve data. It can connect directly to a data store or use a TADOConnection component. | |
|
A simple component for executing commands (SQL statements that do not return result sets); TADOCommand can be used with a supporting dataset component, or retrieve a dataset from a table; It can connect directly to a data store or use a TADOConnection component. |