Btrieve conflict - database unavailable ??

[rosie4]

I moved a database from one laptop to another ( I no longer have access to the original machine ). The software in question, I had previously understood worked on a Pervasive engine, but I now cannot access the data.

The only difference between the two laptopos is the 1st one worked on Windows XP Professional whereas this one is XP Home.

The message I get as soon as attempt to open the Address Book is "Data manager returned an error code of 30." The file is not a Btrieve file or was created by an earlier version of Btrieve"

I have checked all the data file names and they are all in accordance with the software manual.

The database had 2000 + names and addresses + phone numbers with reams of user-defined fields......

Any idea why it would be referring to Btrieve when Pervasive is the engine for that software ?

The data in question is absolutely vital to me, representing my entire client base built up over the last 10 years or so.

 

[mirtheil]

Btrieve is one of the interfaces offered by the Pervasive engine. Usually this error is caused when the file is created with one version of Pervasive and the engine trying to open it is older. For example, if the file was created using Pervasive.SQL V8 but a Btrieve 6.15 engine tries to access it, you'll get the status 30.
What version of WBTRV32.DLL or W3BTRV7.DLL is on the new system?

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

 

[rosie4]

Thanks for the reply.

The version of both those .dll files on the new system is 7.90.230.9 with a create date later than the original databases which are lost.

A later database, created on this machine is viewable normally.

 

[rosie4]

I have since re-installed the same software onto another laptop which runs on Windows XP Professional and it's exactly the same version of Pervasive I mentioned above.

Pervasive engine appears to be OK....is there a possibility of other s/w which uses Pervasive engine causing this ?

 

[mirtheil]

It's very possible other software uses the Pervasive engine. I can think of at least 5 accounting packages, at least 5 medical software packages that all use Pervasive without even trying. It sounds like the other machine had a newer (not older) version of the engine. Pervasive can read and write older file formats, just not newer ones.


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

 

[rosie4]

Sounds reasonable....but is it likely / possible that a laptop on XP professional, purchased almost 2 years ago, would be running on a later version of Pervasive ?

I have just downloaded an upgrade which seems to have brought me up to version 7.94.251.003 but no difference...
Address books will still not open, although I do now get a slighty different message ..additional text:

[Maximizer][ODBC Driver][Btrieve Database]Btrieve Err 30: not a Btrieve file.

Did I mention, I also get message ..A file name error occurred on the Cross Reference file ?

 

[mirtheil]

Well, Pervasive.SQL V8 (the only version of the engine newer thant 7.9x) was originally released in November of 2002 so it is possible. In addition, the Pervasive engine may have been installed by an application last month. The Pervasive engine is in most cases embedded within an applications install. How big is the file zipped? If it zips to under a megabyte, you can send it to me and I'll tell you if it's in V8 format.

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

 

[rosie4]

Many thanks..I have zipped file and e-mailed it to you...

 

[Tankgirl]

Hopefully you can shed some light...
I had to format my pc and reinstall everything - I have the same versions of all software but for some reason I am getting Error 30 on files that were working fine? I am running Pervasive.SQL V8 SP1. Getting this error when trying to open the file through PCC.

 

[mirtheil]

Tankgirl,
You really should start a new thread. A Status 30 could indicate a very corrupt file or an older engine is trying to access the files.
Where are the files (local to your PC or remote)? If remote, what version of the engine is running on the remote machine? Can you open the files with the Btrieve Function Executor? What do you get see when you click "View" then "Btrieve Version" in the Function Executor?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[Tankgirl]

Mirtheil,
Everything is local - get an error when trying to open the file with the Function Executor.
Btrieve status 30
"The file specified is not a MicroKernel file."
Btrieve Version:
Client 8.0
Local MicroKernel 8.10 Win32
Thanks

 

[mirtheil]

Can you open the file using Notepad? Once it's open, please post the first 5 lines here.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[Tankgirl]

Here it is but seems to be a bit garbled:

DÅP€

137007TM108B1040450
ð¿}Ô%­
I²Ô


ÿÿÿÿÿÿÿÿEHE
Tÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ

138007TM108B1040450
ð¿}Ô%­
I²Ô
ÿÿÿÿÿÿÿÿEPEXÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ

139007TM108B1040450
ð¿}Ô%­
I²Ô

ÿÿÿÿÿÿÿÿET
E`ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ
Dà+€

780007TF2900C100350
ð¿}Ô%­
I²Ô
ÿÿÿÿÿÿÿÿ½Bè¾Bÿÿÿÿÿÿÿÿÿÿÿÿ

 

[mirtheil]

That is actually not a Btieve file. Btrieve files have "FC" as the first two bytes (open C:\PVSW\DEMODATA\CLASS.MKD to see this). What's the file name of this file? What application generated this file?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[Tankgirl]

Thanks Mirtheil - I got the client to resend the data - seems when my pc crashed it must have corrupted the files. Tried opening the new file and it seems fine.