SAMPLE: How To Retrieve Relational Data Using OpenXML with ADO in Visual C++ (271775)


The information in this article applies to:

  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
  • ActiveX Data Objects (ADO) 2.6
  • ActiveX Data Objects (ADO) 2.7
  • Microsoft Visual C++, 32-bit Enterprise Edition 6.0
  • Microsoft Visual C++, 32-bit Professional Edition 6.0
  • Microsoft Visual C++, 32-bit Learning Edition 6.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q271775

SUMMARY

OpenXML.exe demonstrates how to retrieve an ADO Recordset from an input XML document by using the OpenXML feature in SQL Server 2000.

MORE INFORMATION

The following file is available for download from the Microsoft Download Center:

OpenXML.exe

Release Date: 10-19-2001

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. The OpenXML.exe file contains the following files:

File nameSize
EULA.txt2 KB
OpenXML.cpp6 KB
XMLDoc.xml1 KB


OpenXML.exe is a SQL Server 2000 extension to Transact-SQL that allows stored procedures to process XML and generate rowsets from the data for use by Transact-SQL statements. In this sample, an ADO client passes an XML document to a stored procedure. The stored procedure runs a SELECT statement, which generates a rowset. This rowset is then returned to the client as an ADO Recordset.

This sample creates a stored procedure named SP_OpenXML_Example on a SQL Server 2000 database and passes an XML document XMLDoc.xml to the stored procedure. The stored procedure processes the document using OpenXML and returns an ADO Recordset back to the client.

Additionally, the SP_OpenXML_Example stored procedure contains calls into the system stored procedures sp_xml_preparedocument and sp_xml_removedocument that load and unload the document from memory respectively. The SP_OpenXML_Example stored procedure is doing the following things:

  1. Runs the sp_xml_preparedocument system stored procedure to prepare the XML document for use by Transact-SQL statements.
  2. Uses the OpenXML-generated rowset in a query.
  3. Runs sp_xml_removedocument to remove the prepared XML document from memory.
For more details about the sp_xml_preparedocument and sp_xml_removedocument stored procedures or about OpenXML, refer to SQL Server 2000 Books OnLine.

Steps to Run the Sample

  1. Create an empty Win32 console application.
  2. Insert OpenXML.cpp into the project.
  3. From the Project menu, click Settings, and then click the C/C++ tab. In the Project Options dialog box, change /MLd to /MTd.
  4. Copy XMLDoc.xml into the project folder.
  5. Compile and then run the application.

REFERENCES

For additional information on XPATH query and XML, click the article numbers below to view the articles in the Microsoft Knowledge Base:

272177 SAMPLE: How to Retrieve XML Data Using an XPATH Query in ATL OLE DB

272185 SAMPLE: How to Retrieve Data Using a SQL XML Query in ATL OLE DB

271780 SAMPLE: How To Retrieve XML Data using a SQL XML Query with ADO in Visual C++

271782 SAMPLE: How To Retrieve XML Data Using an XPATH query with ADO in Visual C++

272180 SAMPLE: How to Retrieve XML Data Using a Template File with ADO in Visual C++

SQL Server 2000 Books OnLine

ADO 2.6 Documentation
Modification Type:MinorLast Reviewed:8/9/2004
Keywords:kbdownload kbfile kbinfo kbMSXMLnosweep KB271775 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.