wx
asked on
How to convert a xml stream into recordset?
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
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
<learning..>
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
Netminder
CS Moderator