�
VB Links
<

ADO Overview

ActiveX Data Objects (ADO) is another API for developing applications that can access OLE DB data providers. ADO is supported in several different programming languages, including Visual Basic, Visual C++, VBScript, Visual J++ and in Active Server Pages. While using the OLE DB providers, ADO provides a higher-level, easier-to-understand mechanism. If you are familiar with the DAO and RDO APIs for application development, ADO will seem very similar. ADO is a combination of the best aspects of DAO and RDO. ADO doesn't rely as heavily on the object hierarchy as DAO and RDO. This means that creating and manipulating ADO objects is much easier, because they can be created and manage directly. ADO is specifically designed for client/server application development, and because ADO can be used from VBScript, it is also well-suited for server-side Web/database integration.

The key features of ADO include:

  • Support for batch updating, in which several record updates are cached and transmitted simultaneously.
  • Support for all types of cursors, including forward-only, keyset, dynamic, and static cursors.
  • Support for server-side stored procedures, which can greatly improve application proficiency.
  • Support for queries that return multiple record sets.
  • Support for query goals, including limits on the number of records returned, active filtering of the records returned, and prepared statements.

While ADO supports all of these features, they still require the OLE DB provider to be used. By using the OLE DB ODBC provider, ADO can be used to access existing ODBC data sources.

ADO is comprised of the following objects: Command, Connection, Error, Field, Parameter, and Recordset.

This section only provides the ADO Overview, I will be providing a complete ADO reference very soon. Please E-mail me at [email protected] or sign my guestbook for comments and/or suggesions. Thanks ALL!!!






<
top





Copyright� 2000 by Noel