ADO Programming with SAP Sybase IQ

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 SAP Sybase IQ OLE DB provider, you get full access to SAP Sybase IQ 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 %ALLUSERSPROFILE%\SybaseIQ\samples\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
  This section describes a simple Visual Basic routine that connects to a database.
• How to Execute Statements Using the Command Object
  This section describes a simple routine that sends a simple SQL statement to the database.
• How to Obtain Result Sets Using the Recordset Object
  The ADO Recordset object represents the result set of a query. You can use it to view data from a database.
• The Recordset Object
  When working with SAP Sybase IQ, the ADO Recordset represents a cursor. You can choose the type of cursor by declaring a CursorType property of the Recordset object before you open the Recordset. The choice of cursor type controls the actions you can take on the Recordset and has performance implications.
• Row Updates Through a Cursor Using the Recordset Object
  The SAP Sybase IQ OLE DB provider lets you update a result set through a cursor. This capability is not available through the MSDASQL provider.
• ADO Transactions
  By default, any change you make to the database using ADO is committed when it is executed. This includes explicit updates, and the UpdateBatch method on a Recordset. However, the previous section illustrated that you can use the BeginTrans and RollbackTrans or CommitTrans methods on the Connection object to use transactions.