BTrieve 6.15 on XP using ODBC errors

[ecloninger]

I inherited a problem today.

Our company has an application that was written by a consultant years ago. The program has worked fine on those machines that needed it until someone got a new machine recently, which has Windows XP.

The program does not work under XP, but it worked under 98 and Me. I get a dialog that mentions "DBIERR_", but no error numbers or description as to the cause of the error. The consultant wrote the application using Delphi 1.0 and BTrieve 6.15 through ODBC but the source code can no longer be reconstructed, so I can't make it 32 bit or use a newer version of BTrieve.

Someone faxed me a set of instructions that mention installing BTrieve, ODBC, Scalable SQL, and BDE. I think most of this is out of date, but the real problem here is that I am not a BTrieve expert. I'm capable of churning out pages of code in MFC/ATL/C++/PHP/etc., but I've only a limited experience with Delphi and BTrieve.

I tried installing 2000i SP3 and it seemed to make things better, but the app just gives a different set of errors about the BDE. So, I installed the BDE and then I get some 16-bit UAE's.

I'm now 8 hours into this and I really don't know if I've made any progress or not. I do have a headache and I think I need a pint of Guinness. Tomorrow, I'll try some more. I'd like to know if there is a definitive answer to "can I run BTrieve 6.15 on XP or not", regardless of the Pervasive support claims. If so, can one of you Pervasive gurus point me in a general direction? I'll happily email a Guinness to whomever can help me out.

Thanks

-E

 

[mirtheil]

In terms of whether Btrieve v6.15 on WIndows XP, I do it here. It does work but there are some caveats. For example, the registry entries are going to be written to HKEY_LOCAL_MACHINE and that requires Power User rights.
The first thing I would try would be to create and ODBC DSN to the data on the WinXP machine. Does that give an error or does it work? If it errors out, what's the error? If it works, then turn on ODBC tracing in the ODBC Adminstrator and see what the actual underlying error is.
if that doesn't help, then it would help to know where the error occurs. DOes it occur at startup of the application or later in the app? If it's later in the app, what's happening?
Pervasive 2000 SP3 is most likely not going to work. The Btrieve 6.15 ODBC was based on the the Scalable SQL engine and that's not supported with P.SQL 2000. THe ODBC DSN entries are different and the SQL syntax is, in some cases, different.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician