ASA Programming Guide
  The OLE DB and ADO Programming Interfaces

ADO programming with Adaptive Server Anywhere

ADO (ActiveX Data Objects) is a data access object model exposed through an Automation interface, which allows client applications to discover the methods and properties of objects at runtime without any prior knowledge of the object. Automation allows scripting languages like Visual Basic to use a standard data access object model. ADO uses OLE DB to provide data access.

Using the Adaptive Server Anywhere OLE DB provider, you get full access to Adaptive Server Anywhere features from an ADO programming environment.

This section describes how to carry out basic tasks while using ADO from Visual Basic. It is not a complete guide to programming using ADO.

Code samples from this section can be found in the following files:

For information on programming in ADO, see your development tool documentation.

Connecting to a database with the Connection object
Executing statements with the Command object
Querying the database with the Recordset object
Working with Recordset object
Updating data through a cursor
Using transactions