Explain MSDataShape in SQLXML 3.0 OLEDB

In this article I will explain MSDataShape in SQLXML 3.0 OLEDB.
  • 1492

Introduction

Data shaping means building hierarchical relationships between two or more logical entities in a query. MSDataShape is a data shaping COM component provided by Microsoft. Data Shaping using MSData Shape allows us to create hierarchial recordsets or recordsets in recordsets.

Syntax :

Provider=MSDATASHAPE;Data Provider=SQLOLEDB;Data Source=server_add;Initial Catalog=database_name;User Id=user_name;password=password;

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answer here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.