×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

access Btrieve db from asp

access Btrieve db from asp

access Btrieve db from asp

(OP)
I am trying to access Btrieve database to display some data in asp page . Btrive version is 5.1 and im using win 2000 componenet server . Now using Pervasive Software ODBC Interface 2.04 Im getting the following error . Can anybody please suggest whats wrong ?

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]General error.

Thanks in advance

RE: access Btrieve db from asp

ODBC 2.04 will only work with Btrieve v6.15.  It won't work with anything older (or newer) for that matter.  I would suggest downloading the Pervasive.SQL 2000i engine from Pervasive's web site (http://www.pervasive.com).  It's the current version of Btrieve and includes an ODBC driver that was tested and supported on Windows 2000 (ODBC 2.04 was never tested/supported on Windows 2000).  
If you really want to try getting the 2.04 to work, which it probably won't, I would suggest turning on ODBC tracing and seeing what error is actually ocurring.

mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: access Btrieve db from asp

(OP)
That means we have to upgrade the Btrieve version . But is there any suitable driver available for accessing data from Btrieve 5.1 ?Please suggest .

Thanks in Advance .

RE: access Btrieve db from asp

As far as I know, there's no driver for Btrieve 5.1.  Btrieve 5.1 was DOS/Win16/OS2 based. There is no 32 bit version of Btrieve 5.1 and as such, no access from 32bit applications (like ODBC/ASP/IIS).  You'll need at least Btrieve v6.15 for WIndows 95/Windows NT or the Btrieve v6.15 server engine to get a 32 bit ODBC driver. However, Btrieve v6.15 and Pervasive.SQL 7.0 are both unsupported.  you should try Pervasive.SQL 2000i.  It's the latest version and is backward compatibile. You do not need to convert the data or the application.

mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: access Btrieve db from asp

(OP)
Thanks for the reply . But i have another question . Is there any way to display Btrieve 5.1 data in asp pages from Win NT using  MTS ?
If so what is the recommmended driver (Im using ODBC )

RE: access Btrieve db from asp

Btrieve v5.1 is either DOS, 16bit Windows, or OS/2 and as such, really isn't able to be accessed from a Win32 app (like ASP or MTS).  You really should upgrade to Pervasive.SQL 2000i.  It's supported and will work with ASP.

mirtheil@mirtheil.com
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