The Microsoft Data Shaping Service for OLE DB service provider supports the construction of hierarchical (shaped) Recordset objects from a data provider.
Provider Keyword
To invoke the Data Shaping Service for OLE DB, specify the following keyword and value in the connection string.
"Provider=MSDataShape"
Dynamic Properties
When this service provider is invoked, the following dynamic properties are added to the Connection object's Properties collection.
| Dynamic Property Name | Description |
| Unique Reshape Names | Indicates whether Recordset objects with duplicate values for their Name properties are allowed. If this dynamic property is True and a new Recordset is created with the same name as an existing Recordset, then the new Recordset object's name is modified to make it unique. If this property is False and a new Recordset is created with the same name as the existing Recordset, both Recordset objects will have the same name. Therefore, neither Recordset can be reshaped as long as both recordsets exist.
The default value of the property is False. |
| Data Provider | Indicates the name of the provider that will supply rows to be shaped. |
You may also set writable dynamic properties by specifying their names as keywords in the connection string. For example, in Microsoft Visual Basic, set the Data Provider dynamic property to "MSDASQL" by specifying:
Dim cn as New ADODB.Connection
cn.Open "Provider=MSDataShape;Data Provider=MSDASQL"
You may also set or retrieve a dynamic property by specifying its name as the index to the Properties property. For example, get and print the current value of the Data Provider dynamic property, then set a new value, like this:
Debug.Print cn.Properties("Data Provider")
cn.Properties("Data Provider") = "MSDASQL"
For more information about data shaping, see Data Shaping.