Hi.

Is there a way to retrieve data from a *.DTA file
other than using butil ?
When I'm putting sth like this:

butil -SAVE <input_file.DTA> <output_file>

I get this:

Btrieve error on <input_file.DTA>. Status = 2.

I have no access to Windows/DOS machine. I'm using
Linux+dosemu to accomplish this.

--
10-4
Pe<>De
Life is an open road to me.
http://www.pld-linux.org/Members/dlugi72

Just to make sure, you DID replace <input_file.DTA> with the name of
your datafile, right? As in:
BUTIL -SAVE FILENAME.DTA OUTPUT.UNF

Also, it might help to know which version your Btrieve file is in, and
which version of Btrieve you are running. Note that Btrieve 5.x engine
will not understand a Btrieve 6.x database file. Also, I'm not sure
which database versions, if any, will run in a dosemu environment.

I'd strongly recommend moving to Pervasive.SQL V8, which provides a true
Linux engine (and now a client) for your use.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: August, 2004: See our web site for details!


John E Singer wrote:

Hi.

Bill Bach wrote:
It was correct

Well, this app runs perfectly in dosemu env. and I just wanted to know
how I could extract data from those files to use it, let's say, in Excel
or sth.
Where in the Net can I find a good walk-thru about migrating from btrieve to
pervasive ?

Thanks for Your assist.

--
10-4
Pe<>De
Life is an open road to me.
http://www.pld-linux.org/Members/dlugi72

Without knowing your database version information, I can't tell you whether you
should be able to use BUTIL to get to the file or not. If you still get a
Status 2, then the file may be actually corrupted.

To access Btrieve files from other applications, there are several options, all
with prerequisites. Please check my white paper list at
www.goldstarsoftware.com/press.asp and see the paper on Accessing Btrieve Data
From ODBC. This gives you a good idea of what is at play here, along with a
link to another paper about determining your database version.

As for "migrating from Btrieiev to Pervasive", there is nothing to do. Simply
install the new engine and run your apps. Underneath Pervasive.SQL is a newer
version of the Microkernel Database Engine that is also at the heart of Btrieve
6.x.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: August, 2004: See our web site for details!


PeDe wrote:

Bill Bach wrote:
When I use btrieve locally from a workstation it shows "5.10a" version
but this error code suggest that those DTA files were created using
different record manager. Possibly 6.x.

Thanks! Need to take a peak.

Would be perfect but somehow I feel it's not that simple
We'll see.

Thanks again for Your assist.

--
10-4
Pe<>De
Life is an open road to me.
http://www.pld-linux.org/Members/dlugi72

Hi again.

Just to clear things out. When I don't have DDF files and there
is no way to get them from the developers of my btrieve app
I just can't figure out the structure of DTA files by myself (or it
would take too long).
Am I correct here ?

--
10-4
Pe<>De
Life is an open road to me.
http://www.pld-linux.org/Members/dlugi72

If the developer provides no DDF's or the structure, then SOMEONE will
need to figure out the structure for you to access it from ODBC. You
would be the most logical choice, since you know thge application the
best. However, other companies, such as ourselves, can also help with
the DDF creation. However, since we don't know the app either, and will
simply need to take a lot of educated guesses, this will take a long
time -- and consequently be quite expensive. (Probably less expensive
than hiring someone to re-key all of the data, though.)
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: August, 2004: See our web site for details!


PeDe wrote: