ADO programming with SQL 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 SQL Anywhere OLE DB provider, you get full access to SQL Anywhere features from an ADO programming environment.

This section describes how to perform 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:

Development tool Sample
Microsoft Visual Basic samples-dir\SQLAnywhere\VBSampler\vbsampler.sln
Microsoft eMbedded Visual Basic 3.0 samples-dir\SQLAnywhere\ADOCE\OLEDB_PocketPC.ebp

For information about 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 the Recordset object
Updating data through a cursor
Using transactions