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 Adaptive Server Anywhere Programming Guide.

Example

The following Visual Basic code initiates an OLE DB connection to Sybase IQ:

' Declare the connection object
Dim myConn as New ADODB.Connection
myConn.Provider = "ASAProv"
myConn.ConnectionString = "Data Source=Sybase IQ Demo"
myConn.Open