I am using rs.save to save the recordset into the xml file.
The code is
<!--#include file="adovbs.inc"-->
Set rs = Server.CreateObject("ADODB.Recordset")
Set c = Server.CreateObject("ADODB.Connection")

c.Open "DSN=dsnname;UID=userid;PWD=password;"
rs.cursorlocation = adUseClient
rs.Open "select * from tablename", c, adOpenStatic
rs.Save server.Mappath("try.xml"), adPersistXML


This code works fine on my local pc but gives error when I host the file on server.
The error is Provider error '80030103' Can't save.

What may be the problem? Any suggestions will be helpfull.


Thanks,
Rahul

Hmmm. I can't be sure, but my first suggestion would be to make sure that MSXML is installed on the Server. My guess is it isn't...

MSXML is installed on the server.

i'm actually getting the same problem...and i'd love to hear a solution. i'm assuming it's a problem with the provider (mine is {Oracle ODBC Driver}) but i've tried many and i still get the same error. does anyone have any working code for a save example?

Just found this explanation:
http://support.microsoft.com/default.aspx?kbid=818518
It's for standalone application, I guess it would apply to Web too.