Contact US

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.

Students Click Here

What are the most common problems with Pervasive Betrieve (pre SQL)

What are the most common problems with Pervasive Betrieve (pre SQL)

What are the most common problems with Pervasive Betrieve (pre SQL)

I hardly have any knowledge of Betrieve but have to write a paper about it...
Can you guys tell me what are the most common problems (technical and application) with this program?

Any help greatly appreciated.


RE: What are the most common problems with Pervasive Betrieve (pre SQL)

What is your artical about.  It sounds like you are looking only for problems.  Of course you should start with the spelling Btrieve not Betrieve.  Also Pervasive now owns Btrieve and there site is www.pervasive.com which would be a good place to start with information.

I've worked with it for 10 years.  It is a very stable and fast database with very very few file corruptions.

As a database it is very good.  As a company they have changed directions a few times over the years, but appear to be back on track.

They dropped XQL which was another API set without much notice and made many developers upset including myself.  It made one of my programs obsolete overnight.

That's my input,



RE: What are the most common problems with Pervasive Betrieve (pre SQL)

As Gil said there is lots of information on Pervasive.com, but I'm really curious why you only want problems? Are you working for a competitor? Will you post the paper as a FAQ here when you get a rough draft?

The main problems with it are:

1) Conflicts with multiple versions of Btrieve or mixed and matched components.

2) Users who don't know how to configure it or update it properly and who really don't understand client/server databases or even peer to peer databases.

3) Use of Btrieve on newer platforms, OSes, and hardware that it was ever tested on. Pervasive stopped testing Btrieve on the latest OSes and hardware in 1998.

Pervasive's flagship product, Pervasive.SQL 2000i has  complete native support for all Btrieve data and applications built in and there are very few problems at all with Pervasive.SQL 2000i except for lack of knowledge of the product and it's uses or use beyond it's intended design capabilities.


RE: What are the most common problems with Pervasive Betrieve (pre SQL)

Actually, I have a problem related to it.  This might be only related to settings but I don't know.

We have COBOL and we use COBOL module to access btrieve.  Just this week, I was modifying a program to use transaction.  So, I did turn logging off, open the files, start transation logging, writes to tables, then if our data validation returns error, program will then abort the transaction.  

The problem is that the transaction did abort with no error but some records were committed.  Have any of you encounted this before?  If so, what was the solution?

It seems to only happen if records inserted is more than 7 - 8 records in a table.  

Thanks and regards.

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! Already a Member? Login

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