reading btrieve 5.12 files using ODBC

[lanegi]

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

 

[mirtheil]

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

 

[lanegi]

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 ?

 

[lanegi]

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

 

[mirtheil]

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

 

[lanegi]

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 ?

 

[mirtheil]

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

 

[lanegi]

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

 

[mirtheil]

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