Hi,

I need to export data in a Btrieve 7.x data file to an ASCII text
file. I do not have the DDF's, I only have the evaluation copy of
Pervasive.SQL v8 (Version 8.60.192.030) installed on my Windows 2000
machine.

Can Pervasive Control Center of Pervasive.SQL v8 be used to export
data from a Btrieve 7.x data file to an ASCII text file? I found that
the Control Center helps do this for the sample.btr data file that
comes as part of the installation. My question is whether this method
be used on a Btrieve 7.x data file.

Thanks in advance!

If your data contains binary data (dates, numbers) you will need the
DDF files in order to convert your data to a readable format.
BUtil.exe will export your data out but the binary fields will show
as garbage. If you need to create DDF files on your existing Btrieve
files you can take a look at BtSearch32 at www.nssdd.com. It can help
you analyze the structure and build the DDF files.

Gil

fcgdoubts (AT) yahoo (DOT) co.in (fcgdoubts) wrote in message news:<7c7b219a.0408310429.cd0e131 (AT) posting (DOT) google.com>...

For more info on what you are trying to do, check out this page:
http://www.goldstarsoftware.com/press.asp -- click on the link for
"Accessing Btrieve Files From ODBC" for details.
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!


fcgdoubts wrote:

Hi,

Correct me if I am wrong, so basically what you are saying is that
Pervasive Control Center of Pervasive.SQL v8 cannot export data from a
Btrieve 7.x data file unless I have the DDF's. Is my understanding
correct?

As I mentioned earlier, I exported the data from the sample.btr data
file without using the DDF's. How did Pervasive Control Center manage
to get the data out then?

Thanks again!



nelsonsoft (AT) hotmail (DOT) com (Gil) wrote in message news:<a5c2e6de.0408311357.53eac76 (AT) posting (DOT) google.com>...

If you exported from the Pervasive Control panel you would have
selected the table to export. That table exists inside the DDF files.
The only way you can make a connection to your databases thru the
control panel is to have the DDF files. However, there is an external
utility called Maintenance which will allow you to take a Btrieve file
and export it out to text. However, if you viewed the results of the
resulting text file you will notice the garbage characters near the
beginning of each record. This is a binary field. So in order to
view that information in a readable format you must have the DDF
files. Once you do and it describes each field then you could use the
Control panel to export your data or use other 3-rd party software
including ODBC. Hope that helps.

Gil


fcgdoubts (AT) yahoo (DOT) co.in (fcgdoubts) wrote in message news:<7c7b219a.0408312342.3100d700 (AT) posting (DOT) google.com>...

Hi,

Thank you for your response.

My client does not have the DDF's, so I guess I'll have to try
building them using BtSearch32. Is this a very complicated process? I
am asking this because I have to give an estimate to the client.

I do not have access to the client's Btrieve 7.x data file as yet. I
searched everywhere on the Internet for a sample Btrieve 7.x data
file, but I did not find any. I would be grateful to anyone who can
send me a sample Btrieve 7.x data file so that I can start learning
how to create DDF's.

I request anyone who has a sample(any dummy data will do)Btrieve 7.x
data file to mail it to me at fcgdoubts (AT) yahoo (DOT) co.in

Thanks a lot.

nelsonsoft (AT) hotmail (DOT) com (Gil) wrote in message news:<a5c2e6de.0409010826.e1a4561 (AT) posting (DOT) google.com>...

I'm going to email you directly on this. But for a sample database
you can download the trial version of Pervasive V8 which contains a
set of files and DDF files so you can review them.

Gil

fcgdoubts (AT) yahoo (DOT) co.in (fcgdoubts) wrote in message news:<7c7b219a.0409012117.40e3514a (AT) posting (DOT) google.com>...