Microsoft ActiveX Data Objects (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:
The Provider property holds the name of the provider. If you do not supply a Provider name, ADO uses the MSDASQL provider.
The ConnectionString property holds a connection string. This property holds an ASE connection string. You can supply OLE DB data source names, or explicit UserID, Password, DatabaseName, and other parameters, just as in other connection strings.
The Open method uses the connection objects to initiate a connection.