INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

btrieve/N version 5.10 dos exporting from

btrieve/N version 5.10 dos exporting from

(OP)
I need a little help.  A client of mine has an old btrieve program that some some data in it he would like converted to a dbf file he has.  I have tried butils.exe to extract data thru the -SAVE function. I returns garbage.  I have tried btsearch but under the description section is only gives half file names and no records.  Any help would be greatly appreciated.

RE: btrieve/N version 5.10 dos exporting from

BUTIL -SAVE doesn't return garbage unless the file is corrupted.  What BUTIL-SAVE does return is a byte image of the record.  Btrieve does not store field meta data so, typically, only the application knows the structure of the record.  If you know the structure of the data, you can create DDFs so you can use ODBC.  
Having not worked with Btsearch, I can't say why it would return only half of the files.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: btrieve/N version 5.10 dos exporting from

(OP)
They Structure of the data is store in what looks like .def files.  So I know exact layout of each file. But what would I do from there

RE: btrieve/N version 5.10 dos exporting from

Well, first you're going to need to get a newer version of Btrieve/Pervasive.  Btrieve 5.10 was DOS, Win16, NetWare, and OS/2 only.  To use ODBC you're going to need a 32 bit version.  The current version is Pervasive.SQL V8 and a trial version is available for download from http://www.pervasive.com.  Once you've got that, then you can use either the Create Table WIzard or SQL statements to create tables.  If you use SQL statements, make sure to turn off TrueNullCreates by issuing:
Set TrueNullCreate=Off
before issuing any Create Table SQL statements.  This will prevent an extra byte from being inserted into the table defintion.  You'll also want to use the "USING" and "IN DICTIONARY" clause so you're only affecting the DDFs and not the data files.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: btrieve/N version 5.10 dos exporting from

If you need to export to dbf you can take a look at BtSearch at www.nssdd.com.  If you do not have the DDF files which are the data dictionary files it also allows you to analzye the structure and build the DDf files.

Gil

RE: btrieve/N version 5.10 dos exporting from

The garbage seen using BUTIL -Save may just be binary data, not necessarily corrupt data. Binary data can have code for carriage return/line feed which may wreak havoc with most text editors. The .def files may equate to Btrieve description files which are used with the BUTIL -Create function. They can provide some information about the record length and keys within the data. You do need to create ddf's to map all field data. BTSearch attempts to generate DDF's from the database by attempting to isolate fields.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close