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.
Databases

Avatar of undefined
Last Comment
novologik

8/22/2022 - Mon
BCipollone

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.
Bill Bach

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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
novologik

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.....
Bill Bach

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.

ASKER
novologik

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Bill Bach

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.
ASKER
novologik

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
Bill Bach

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
novologik

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!!!!!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes