Required Providers for Data Shaping
Data shaping typically requires two providers. The service provider, Data Shaping Service for OLE DB, supplies the data shaping functionality, and a data provider, such as the OLE DB Provider for SQL Server, supplies rows of data to populate the shaped Recordset.
The name of the service provider can be specified as the value of the Connection object Provider property, or the connection string keyword, "Provider=".
The name of the data provider can be specified as the value of the "Data Provider" dynamic property which is added to the Connection object Properties collection by the Data Shaping Service for OLE DB, or the connection string keyword, "Data Provider=".
No data provider is required if the Recordset is not populated (for example, as in a fabricated Recordset where columns are created with the NEW keyword). In that case specify "Data Provider=none".
Example
Dim cnn As New ADODB.Connection
cnn.Provider = "MSDataShape"
cnn.Open "Data Provider=MSDASQL;DSN=vfox;uid=sa;pwd=vfox;database=Pubs”