Contents Index OLE DB providers Connection parameters

ASA Database Administration Guide
  Connecting to a Database
    Connecting to a database using OLE DB

Connecting from ADO


ADO is an object-oriented programming interface. In ADO, the Connection object represents a unique session with a data source.

You can use the following Connection object features to initiate a connection:

For more information about ADO, see ADO programming with Adaptive Server Anywhere.

Example 

The following Visual Basic code initiates an OLE DB connection to Adaptive Server Anywhere:

' Declare the connection object
Dim myConn as New ADODB.Connection
myConn.Provider = "ASAProv"
myConn.ConnectionString = "Data Source=ASA 9.0 Sample"
myConn.Open

Contents Index OLE DB providers Connection parameters