Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2008
    Posts
    7

    Unanswered: Inside another program

    Hello,
    i have to export some datas from a program that uses Pervasive SQL. I found some data files and other XML file with the schemas.
    Now i don't know how to open them, how I have to use the xml schemas?
    How Pervasive works? Is it only a serial file db?

    Thanks

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Short answer:
    Pervasive is a flat file DB in some cases. There is relational (SQL) access in some cases. You would need DDF files (FILE.DDF, FIELD.DDF, and INDEX.DDF) that describe the data files. You would get them from the application vendor (not Pervasive). Once you have them, you can use ODBC to export the data.

    You'll want to read the white paper at http://www.goldstarsoftware.com/btrvodbc.asp.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Oct 2008
    Posts
    7
    I'm not sure, but maybe that I can create the DDF files from an xml schema? Because in this app, i have some file like this: clients.08 (file extension change by year, so the db files of last year was clients.07) and a clients.xml with something like this:
    Code:
    <Root>
    	<forn strName="forn" strType="String" strLen="3"/>
    	<cat_mer strName="cat_mer" strType="String" strLen="2"/>
    	<progre strName="progre" strType="String" strLen="4"/>
    	<desc strName="desc" strType="String" strLen="60" />
            ....
    </Root>
    I'm not 100% sure that this is a pervasive db, but i saw it installed on its server and seems to be the only db.
    Have you got any ideas if this can be the pervasive and if i can get DDP files from the xml schemas informations?

    Thanks.

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Pervasive doesn't use XML files. If you open one of the data files in a text editor, you should see "FC" as the first two characters. You can also use one of the Pervasive tools like BUTIL to check the data file.
    You might be able to use the information in the XML files to generate the DDFs.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Oct 2008
    Posts
    7
    Yes, the first two chars is "FC", I also tried to read sequential bytes with a row Basic Open function by bytes lenght steps but i get nothing useful. Do you know how to read that? In their server there is the Pervasive Control Center, but in the Databases list there is only the demo tables, and not this one. Do you think their app writes in the db directly or using the Odbc? How can i understand it?

    thank you very much,

  6. #6
    Join Date
    May 2005
    Posts
    15
    If you need to build the DDF files you can take a look at BtSearch 2008 at www.nssdd.com. It helps you analyze the data and then builds the DDF files. If you have the XML schema and it is accurate then at least it may help you in the process of defining your fields although BtSearch does not directly make use of them.
    Gil

Posting Permissions

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