Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Btrieve 6.15 & ASP

Status
Not open for further replies.

not24

Programmer
Feb 25, 2002
68
US
I have installed Pervasiave ODBC Driver 2.04 and I have Btrieve databsae engine installed. I also tested create DDF file from an existing database. There are a lot of *.BTR in that folder but I just created 2 of them just wanted to test ASP code. Then I copied example code to test connection and runned it but I've got an error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)

[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]The table is not defined in the dictionary.

And when I tried to link this from MS Access, I also got this error:

ODBC--call failed.
[Pervasive Software][ODBC Interface]Driver not capable. (#0).

My question is:

1. Would ASP be able to show data from Btrieve 6.15 at all?

2. Is there anyway I can have ASP pull data from Btrieve 6.15 without upgrade database engine? I mean mostly of data belong to the customer, I can't really upgrade theirs without effect the software that they using right now.

3. Any 3rd Party stuff that will work with ASP?

Please advice,
 
SQLScope was a utility for running SQL queries against a Btrieve database. It used Scalable SQL (same as the ODBC 2.04) however it was not included with Btrieve v6.15 or ODBC 2.04. I would recommend checking the code to make sure that the datasource name specified on the connect is correct. If it can't find the table name, it may not be defined. You should also check the Select statement in the ASP page to verify that it is accessing a correct (ie defined) table. In terms of Access, I would try a SQL Pass through query. It will bypass the JET engine and use ODBC directly.
The other, better option is to upgrade to Pervasive.SQL 2000i THe ODBC driver included with 2000i is supported in an ASP environment while the ODBC v2.04 was never thread safe and could cause problems with thread issues in a web environment. Check out the trial version at mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top