July 30, 2001 at 7:14 am
hi,
i am working with sql server6.5.Data gets updated continiously.For each updation i need to create xml file.could some one help me out.
thanks in advance
July 30, 2001 at 12:15 pm
Any chance you could upgrade to 2000?
If not, you can use ADO to run a query from VB/ASP/VBS and then save the query as an XML file.
Steve Jones
July 30, 2001 at 8:13 pm
Steve's suggestion is a good one. Plenty of reasons to upgrade to SQL2K and XML support is included.
If that's all you need though, just remember that an XML document is nothing but a big string. Easy enough to write some code to generate XML - VBScript would give you easy access to the filesystem/textstream objects, all you need to create xml. Run as a job and call it done!
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply