Connecting to a Simple Provider Using ActiveX Data Objects (ADO)

ADO, as an OLE DB consumer, makes requests to a provider to access data sources and retrieve the desired information. In ADO, you supply the name of the provider either as part of a connection string , or in the Provider property of the Connection object. The steps to make the connection depends on whether your Simple Provider is registered as a full OLE DB Provider or not.

• Simple Provider Registered as a full OLE DB Provider

  In the following example, when the Simple Provider is registered as a full OLE DB provider, the steps are:

  1. Supply the ProgID of your Simple Provider, in this case, SampleOSP_VB, as a parameter to the Provider method of the Connection object.
     
     
  2. Open the connection.
     
     
  3. Set the Recordset Object's source to the Data Member of your provider's Data Source Object.

  The corresponding code follows:

  con.Provider = "SampleOSP_VB"
  con.Open
  rs.Open " C:\Oledbsdk\Osptk\Samples\Customer.txt", con
  

• Simple Provider Not Registered as a full OLE DB Provider, but it's Data Source Object is Registered

  In the following example, when the Simple Provider is not registered as a full OLE DB provider, but it's Data Source Object is registered, the steps are:

  1. Supply the ProgID of the OLE DB Simple Provider DLL (the mapping layer), in this case, MSDAOSP, as a parameter to the Provider method of the Connection object.
     
     
  2. Supply the name of your simple provider's Data Source Object, in this case, SampleOSP_VB.MyDataSource, as a parameter to the Properties method of the Connection object.
     
     
  3. Open the connection.
     
     
  4. Set the Recordset Object's source to the Data Member of your provider's Data Source Object.

  The corresponding code follows:

  con.Provider = "MSDAOSP"
  con.Properties("Data Source") = "SampleOSP_VB.MyDataSource"
  con.Open
  rs.Open " C:\Oledbsdk\Osptk\Samples\Customer.txt", con