XML Output

[jalbao]

i'm using sql server 7.0 for a web application.

is there "best" method for sending the results of a query in xml format? i am aware that sql server 2k can output xml, but what about version 7?

i am trying to figure out a way to send a record set to the client side so that the client can manipulate and filter the data.

 

[sandeepdey]

i am also using sql7.0 and have the same problem of xml output. By the way i have vb6.0 to use this. i agree this is a long way but it works.

Sandeep

 

[jalbao]

when you say you have vb6 to use this, do you mean that you built an activeX control or something similar via vb6?

 

[Guest_imported]

actually, i'd like to do the same thing, but as the upgrade from 7 to 2000 is easy, i just chose to start the thing in sql2000. My problem is, can i use just the sql itself to send XML? from what i understtod, the IIS links with the sql and then you can call an asp page to retrieve the XML you want.
What i wanted was to make the SQL engine itself send the XML. I know(remember?) that the 7.0 can save content directly into hml files.
Is there a way i can use the sql2000 to save/send the XML?
Because i don't want to build a COM object to that job...... 8/