Using ActiveX Data Objects

ADO Summary

There are advantages and disadvantages to using ADO.

Advantages

The advantages of using ADO include:

• A unified standard

  The ADO model strives to expose everything that the underlying data provider can do, while still adding value by providing shortcuts for common operations.

• Extensibility

  In the future, ADO will become a superset of RDO.

• COM interface

  Because ADO is a COM-based component, any application or language capable of working with COM objects can use itincluding Visual Basic. At this time there is no licensing restriction for ADO.

• Active Server Pages

  ADO scripts are written with Microsoft Visual Basic Scripting edition.

Disadvantages

The disadvantages of using ADO include:

• Not yet fully developed.
• It is a higher level interface than OLE DB