B-trieve database & ASP

[not24]

I'm not familar with B-trieve. Mostly, I implement ASP to access data from SQL 7.0 or Access. Here is my questions:

1. How can I access B-trieve database (I think it's version 6.15)? I just need to get data to compare with another database (access, dbase and sql), no add or update at all.
2. Do I need ODBC?
3. I read from forum that I may need to create DDF. Where I can download tool to create DDF?
4. Should I export B-trieve database to be something like access or SQL or text file (if possible) every now and then for the purpose of accessing by ASP script? Or it's not such a good idea? (By the way, this database still updating every day from another software).
5. I have a little experienced on create MTS Component to execute sql command but very little. Is there anyway I can create MTS Component to get data from B-trieve?

Please advice.

CM

 

[mirtheil]

To answer your questions:
1. check out the Pervasive Component Zone(

http://www.pervasive.com/componentzone).

There should be a sample ASP page. If not, email me (mirtheil@mirtheil.com) and I'll send you a copy of one I have here.
2. Unless you write your own data layer as an ISAPI dll, you will need ODBC.
3. Again, check Component Zone. There are several third party tools. You will need to know the structure of the tables.
4. Exporting probably isn't a good idea. It'll be slow (because you have to export then access the data) and won't be against live data.
5. I haven't tried to create an MTS component but in my opinion, sticking with ASP/ODBC would be the easiest way to do it.
Hope this helps.
Mirtheil
mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[grnelson]

If you don't have DDF files you will need these to use ODBC. You can use BtSearch at

http://www.nssdd.com

to help you create these files. Once created you just set up your ODBC connection.

Gil

 

[not24]

What version of BtSearch I can use? 32-bit or 16-bit?

 

[grnelson]

The 32-bit version has additional DDF editing capabilities and that would be the one I would recommend. I
Gil