Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » OLE DB and ADO development


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 %SQLANYSAMP16%\SQLAnywhere\VBSampler\vbsampler.sln project file.

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

How to connect to a database using the Connection object
How to execute statements using the Command object
How to obtain result sets using the Recordset object
The Recordset object
Row updates through a cursor using the Recordset object
ADO transactions