Persist ADTG not Working

Discussion in 'ASP General' started by Susanth Sivaram, Jun 30, 2003.

  1. Hi,
    I was trying to save a record set in ADTG format. using the following
    rs.Open strSQL, conn
    rs.Save "D:\sql7.adtg",0

    Later I try to retrive the data from the file using the following code.
    rs.Open "D:\sql7.adtg","Provider=MSPersist",,,adCmdFile

    But I had problems while retrieving the data from the file. Some fields
    come properly. But the varchar or the String fields has some problem. When
    the data is retrieved and written to a flat file to the harddisk, some junk
    value is written. For eg. The varchar field is 20 chars wide and the value
    in that is 10 chars wide. The rest 10 characters shows up some junk value.
    This can be known while appending some other value to the retrieved value.
    When I directly retrieve from the database, I dont have any problem.

    I had also tried the other format adPersistXML. That also didnt work.
    While retrieving I tried to retrieve with and without the connection. That
    also didnt work.

    The database used is RedBrick. But I am not sure whether this has to do
    anything with the database. Please help.

    Susanth Sivaram
    Susanth Sivaram, Jun 30, 2003
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.