Insert/Delete/Update records in ASP application

[Guest_imported]

Hi, guys

I am working on a small ASP application which intends for users to update Maximizer(Pervasive/Btrieve) database through web.

Here is my question, what is the best way to access Maximizer database? Do I need to have through knowledge about Pervasive database? Can I just use table names(which I can view in Access) in SQL queries?

This is the first time I deal with Pervasive database. Any help will be deeply appreciated.

Thanks

 

[mirtheil]

Using ASP, you have two options. One option is to create an ISAPI DLL that can be called from the ASP page to access the files directly through the Btrieve API or ODBC. The other option is to use ODBC. If you're not familiar with Btrieve, I would recommend using the ODBC driver from ASP with ADO. You can issue Select, Insert, Delete, and Update statements.
mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician