RSS issues

[tcadieux]

Folkz, my boss has asked me to take our news feed and make an RSS out of it, no problem. That was until i realised I am not allowed to use FSO to build an XML file on the server that houses our database. I can use FSO on our Apps server, but i'm not sure if i can query our SQL db from the Apps server.

I tried just making a dynamic XML file but the RSS readers don;t appear to read anything but a afile ending in XML.

Has anyone tackled this type of thing before?

[tcadieux]

I guess this is a toughie

[degsy]

Firstly you will have to setup the database so that you can access it over the network and have permissions to query it.

If you do that and you have IIS running on the ASP server then you can use ASP to query the database and create the feed.