Contact US

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.

Students Click Here

Btrieve 6.15 & ASP

Btrieve 6.15 & ASP

Btrieve 6.15 & ASP

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,

RE: Btrieve 6.15 & ASP

Does the SQL work if you use SQLScope?

RE: Btrieve 6.15 & ASP

What's SQLScope?

RE: Btrieve 6.15 & ASP

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 http://www.pervasive.com/downloads

Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

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! Already a Member? Login

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