INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

reading btrieve 5.12 files using ODBC

reading btrieve 5.12 files using ODBC

(OP)
I have an old DOS app that uses btrieve 5.12 engine / btrieve 6.15 engine. (they can both read the data files of version 5).

I want to keep the data files as they are but connect and manipulate the same files from ASP pages.

I understand I need an ODBC driver for this.

Please correct me if I am wrong and if not please advise where can I get / pucrhase this ODBC driver (or any other solution you advise)

Regards

RE: reading btrieve 5.12 files using ODBC

If you've got DDFs for the data files, you can use ODBC. IF not, you'll need to build them (or get them from the vendor).
Once you have DDFs, you can probably get an ODBC driver from Data Direct. I believe they have one that works with Btrieve 6.15.  If not, you'll need to upgrade to Pervasive.SQL V8 or V9 (available at http://www.pervasive.com/downloads).  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: reading btrieve 5.12 files using ODBC

(OP)
I have no problem building the DDF files since I am the developper of the package. Do you know if the odbc driver can function in the same time as the DOS application is working (which uses the btrieve API) or I can expect collisions between them, If I run it all on XP Pro with IIS ?

RE: reading btrieve 5.12 files using ODBC

(OP)
another question: is an ODBC driver for btrieve files available only from DataDirect or other vendors also have. This is huge application which were build specifically for my kindergardens. There is no point to invest lot's of mony in it but it is very usefull so we do not want to through it away.

Regards

ori

RE: reading btrieve 5.12 files using ODBC

For Btrieve v6.15, there were only two ODBC drivers that I'm aware of.  One is from Data Direct. The other was from Pervasive (Btrieve).  THe Pervasive driver for 6.15 isn't available any more.  
If you can upgrade to Pervasive V8 or V9, you can use ODBC and DOS apps at the same time.  
You can have only one version of the engine accessing the files at any given time.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: reading btrieve 5.12 files using ODBC

(OP)
what is the procedure to upgrade from files of version 5.12 to 9, and do I have to recompile or do API changes in the DOS app ?

RE: reading btrieve 5.12 files using ODBC

You shouldn't have to recompile the DOS app.  
If your are using V9, you will need to rebuild the V5 files to at least v6 format. V9 only accesses V5.x (and older) files in read only mode. TO rebuild, use the Rebuild Utility.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: reading btrieve 5.12 files using ODBC

(OP)
ok it don't sound like a big deal.
Do you know which package of version 9 do I need for my app:
We are running it today from 2 xp computers pointing to the same folder in 1 of the computers where all the data files are located.
The is a resident engine running in each computer before we start the dos program.
I want the computer which hold the data files to have the IIS too and be the web server.

Thanks a lot for all you help

Ori

RE: reading btrieve 5.12 files using ODBC

If you're serving files over the web, you'll need the Intranet/Internet license. I belive it comes with the Server Engine.  With the server engine, your dos apps on the clients will use the client requesters and use the engine on the server to open the data.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

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!

Resources

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