MSDataShape

This Data Shaping COM component is provided by Microsoft. The main functionality of the wrapper COM component is contained in the file msadds.dll.

Include "Provider=MSDataShape;Data Provider=providername" in the connection string to use this wrapper COM component.

Description

Data Shaping using MSDataShape allows you to create hierarchial recordsets, or "recordsets in recordset". This way you can browse relational data in a convenient way. Say for instance you have a Persons table and an Orders table. Using data shaping you can retrieve one recordset containing persons and for each person record in that recordset loop through that persons Orders recordset.

More info about this wrapper COM component can be found at the Microsoft product page.

Download

There is no 'MSDataShape' installation package to download. (if you know about an installation package URL you can contribute to the community by submitting the info to us through this message form)

Connection Strings

The MSDataShape wrapper COM component can be used to connect to the following data sources by using the following connection string references:

SQL ServerSQL Server 2000SQL Server 7.0Oracle

Providers

.NET Framework Data Provider for SQL Server Microsoft OLE DB Provider for SQL Server Microsoft SqlClient Data Provider for SQL Server SQL Server Native Client 10.0 OLE DB Provider SQL Native Client 9.0 OLE DB Provider SQL Server Native Client 10.0 ODBC Driver SQL Native Client 9.0 ODBC Driver Oracle Data Provider for .NET / ODP.NET Oracle Provider for OLE DB .NET Framework Data Provider for Oracle Microsoft SQL Server ODBC Driver .NET Framework Data Provider for OLE DB Microsoft ODBC for Oracle .NET Framework Data Provider for ODBC Oracle in OraClient11g_home1 SQLXML 3.0 OLEDB Provider Microsoft OLE DB Provider for Oracle Oracle in OraHome92 Oracle in XEClient Microsoft ODBC Driver for Oracle dotConnect for Oracle Microsoft OLE DB Driver for SQL Server Microsoft ODBC Driver 17 for SQL Server Microsoft ODBC Driver 13 for SQL Server Microsoft ODBC Driver 11 for SQL Server SQL Server Native Client 11.0 OLE DB Provider SQL Server Native Client 11.0 ODBC Driver SQLXML 4.0 OLEDB Provider Context Connection

Articles

read all »
Network Protocol for SQL Server Connection All SQL Server SqlConnection Properties Application Name for SQL Server Connections SQL Server Data Types Reference When to use the SQL Native Client SQL Server 2000 Data Types Reference The new Microsoft.Data.SqlClient explained SQL Server 2005 Data Types Reference SQL Server 2008 Data Types Reference SQL Server 2012 Data Types Reference