Link to home
Start Free TrialLog in
Avatar of novologik
novologik

asked on

how to read BTrieve 6.x data

I need a way to read and extract data form .dat BTreive file.
Avatar of BCipollone
BCipollone
Flag of United States of America image

Avatar of DonConsolio
Btrieve 6 uses ISAM files and does not have a data dictionary.
If you are lucky you may also have  some .ddf files which provide
the data dictionary for easier access.

To read this file without .ddf files you need  the description of the
file structure (field types, length, name) to access the data.
Then you can write a program and export the data or create some
.ddf files if you have access to the needed tools (see post above).

If you have working .ddf files and you can access your data with
either with Xtrieve (old), Pervasive.SQL  (current BTrieve version)
or 3rd party tools.

The best solution probably is to export via the corresponding application
(if possible) or to write a small export program if you gave access to
the file description or .ddf files.
Here's another white paper to get you started:
    http://www.goldstarsoftware.com/papers/AccessingBtrieveDataFromODBC.pdf

It also includes a way to export the data from Btrieve format to UNF format -- which may take one more step out of the data transfer process.
Avatar of novologik
novologik

ASKER

Hi guys,

BCipollone: Thanks for the answer ...but those tools dosent work because I don't have BTrieve install on my machine.

DonConsolio: Yes I have all the ddf files and I'm able to read them with a third party software....I can read the data to but the third party sotware I used dosen't work very good when I read and export the data.... I tried with Pervasive 11 (the lastes version) I can read the dbf but not the data...maybe there's a to big difference with the data version.

BillBach: I take a look to the pdf and I will try the Pervasive version 9. I'll give you new later....

Thanks guys.....
The DDF's can be likened to a "transparency" overlay that defines the underlying Btrieve files.  If your DDF definitions don't match the Btrieve definitions, then you'll have all sorts of problems.  Check around and see if you can find a new set of DDF's (from the developer, if needed).  Note that PSQLv11 is current, and PSQLv9 won't give you any different results.  If the DDF's are bad, then you need new ones -- no question about it.

PSQLv11 also has a component called the "DDF Builder", and this can be used to either modify your existing DDF's or create new ones.  Having access to original source code is VERY helpful in this regard.

Yes...I understand....The developper is one of my competitor...I just sell my software to one of his customer....I need to access the data to transfer in my SQL Server database....I would like to be able to do that without contact them....!!!! I test with version 9 and it's not working....But I found a version of BTrieve (Pervasive SQL 2000) and I read that this version will be able to read the BTrieve data without any problem.

If I have the right version with DDF file, did I will be able to read them? If the DDF file are not perfert at 100% it will work are not?

Thanks
All versions of Pervasive PSQL *are* Btrieve.  Btrieve 6.15 was replaced by Pervasive.SQL 7, which was replaced by Pervasive.SQL 2000i.  Then came Pervasive.SQL V8, then Pervasive PSQL v9, Pervasive PSQL Summit v10, and now Pervasive PSQL v11.  They will all work the same way.  All can read the data, and all will require DDF's to read it directly from SQL.  

If the DDF's are CLOSE then you may be able to get most opf what you want.  If they are not close, then you'll be out of luck.  

As a developer, you have other options.  Instead of writing your own Btrieve application, though, use the BUTIL command to export the data to a UNF file, and then write your own application to parse the UNF file as described in the white paper.  Yes, this is a lot of work, but in the absence of DDF's, it is your only option.
Hi BillBach,

Do you have more information about the BUTIL command? I think I will need to go through that big process because the DDF files are not perfect and somme infomation cannot be transfer correctly.

P.S.: I use BTSearch 2009 ... it work fine ....only if your DDF files are perfect.
ASKER CERTIFIED SOLUTION
Avatar of Bill Bach
Bill Bach
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I finaly find a guy in california who recreate the ddf files for me and after that everything work fine. That guy is the one who create BTSearch 2009 software!!!!!

Thanks every one!!!!!