Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Btrieve version & BtSearch32

Status
Not open for further replies.

not24

Programmer
Feb 25, 2002
68
US
I have master.btr, Disk0000.btr, Archives.hst, Dataid, Note.btr and Patient.btr. I search in register it says Btrieve 6.15. How can I know if it's really Btrieve version 6.15? I have the medical record software and Btrieve's ODBC on my test machine (client).

I also download BtSearch32 from I have to admit that I know nothing about btrieve database. I'm not quite sure what's kind of Btrieve database structure. Is it like relational database? or something else? I'm not sure which *.btr is the one that keep all data?

When I open patient.btr with BtSearch32, I didn't see any field name. I'm not use if it's open that file without problem or not.

Also an example on they show btrieve database's extension ".DAT". I don't have one. Is that file new version of Btrieve database?

Please advice.
 
A btrieve file does not have to have a .dat extension. In fact all of the .DAT files I have seen are old btrieve files - v6.15 or older.

To see what file contains the data, go into your application and make a change to a data file. Then go to windows explorer and see what data file(s) were updated. You may have to do this when other users are not using these files, obviously.

Do you have file.ddf, field.ddf and index.ddf? And if so do you have crystal reports? If so write a crystal report to see what is in what file.

You also mentioned you have Btrieve ODBC installed. You can create a link table in MS access to browes the raw data. You may have to create a DSN in control panel 32 bit ODBC data sources first. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com
 
As was already mentioned Btrieve files can have any extension. To use ODBC or any 3-rd party products you must have the DDF files (file.ddf, field.ddf and index.ddf). If you don't have these then you have two options. One is to contact the original vendors and see if they will provide them and second you will need to build them using a tool like BtSearch32 at Once you have these built then you can use BtSearch or Crystal or ODBC to access your data files.

Btrieve files my nature are transactional files and not relational. However, using ODBC you can create the same effect as a relational file and the newer versions of Pervasive Btrieve have even more features than 6.15 in this regard. Gil
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top