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

Accessing Btrieve 5.1 Table from Visual Foxpro

Accessing Btrieve 5.1 Table from Visual Foxpro

Accessing Btrieve 5.1 Table from Visual Foxpro


One of my client is using Btrieve 5.1 in a Dos environment, They need to do some reporting on a data store in a btrieve database, i.e. CusOrder.Btr,  I would like to find out if there is anyway where I can access this table directly from Visual Foxpro 9, as far as I know from reading the internet, there is no option, however I came across a tool called raSQL that seems to be able to do that.  
Had anyone use this tools?  and if so, does it work with VFP9?

Also someone mentioned that I have to install Pervasive.SQL V8 WorkGroup Engine (WGE) to access the Btrieve database? will this work?

Thank you in advance,

Chieh Z

RE: Accessing Btrieve 5.1 Table from Visual Foxpro

Assuming VFP9 is a Win32 application, there will be no way to use the Btrieve 5.1 engine to access the data.  
VFP has supported ODBC in the past and if you've got DDFs, you could try creating an ODBC DSN using the Pervasive.SQL WGE (V8 or V9) and then use that DSN from VFP.  
As far as raSQL, I've not used it but it would run into the same limitations as above (if it's 32 bit, it can't access Btrieve 5.1).  

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

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