Results 1 to 5 of 5

Thread: rs.save method

  1. #1
    Join Date
    Feb 2003
    Posts
    18

    Arrow Unanswered: rs.save method

    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

  2. #2
    Join Date
    Jul 2003
    Location
    Albany, NY
    Posts
    3

    Re: rs.save method

    Originally posted by rahulqa
    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.
    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...

  3. #3
    Join Date
    Feb 2003
    Posts
    18
    MSXML is installed on the server.

  4. #4
    Join Date
    Jul 2003
    Posts
    3

    Unhappy

    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?

  5. #5
    Join Date
    Dec 2003
    Posts
    1

    Can't Save ADO recordset into XML file

    Originally posted by Compaqx101x
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •