We help IT Professionals succeed at work.

How to convert a xml stream into recordset?

wx
wx asked
on
Medium Priority
315 Views
Last Modified: 2012-06-27
Hi experts,
I have a SQL2000 stored procedure which uses FOR XML RAW,XMLDATA feature to generate xml stream, and one server component which uses adoStream object to call the above stored procedure and get xml stream then send it back to client end as variant data type. My question is how the client end converts this variant data into record set?

Thanks in advance

Comment
Watch Question

Ryan ChongSoftware Tead Lead / Business Analyst / System Analyst / Data Engineer
CERTIFIED EXPERT

Commented:
<learning..>

Commented:
wx
I am not so sure about using SQL Server with ADO, but I use MS Access with ADO.  What I did was that I would extract the data via the SQL query into a recordset.  Then I would use a parser to create the XML nodes and objects using the MSXML30.dll.  I created a XSLT page to provide the template for display and then do a transformation and to get the result of the page to the client.

Alternatively, you can create the XML via the ASP pages and point the transformation to the XSLT page.

The only problem is that the client would need to install MSXML30.dll if not it would not worked.

I know this is very general as I am not sure if this is what you want.  If you are keen to take a look at some codes do post here.

Hope this helps
Ivanc
CERTIFIED EXPERT
Author of the Year 2009

Commented:
Hi wx,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept etmendz's comment(s) as an answer.

wx, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
Per recommendation, force-accepted.

Netminder
CS Moderator

Explore More ContentExplore courses, solutions, and other research materials related to this topic.