access Btrieve db from asp

[Guest_imported]

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

 

[mirtheil]

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

 

[Guest_imported]

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 .

 

[mirtheil]

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

 

[Guest_imported]

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 )

 

[mirtheil]

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