PERVASIVE SQL 7/8 INFORMATION REQUESTED

[infobit]

Hi,
my name's Roberto and I write from Italy.

I'm a VB developer and it's about 12 years every day I use
Pervasive as SQL Engine for my applications.
12 years ago I used Btrieve, then 4 years later I
started working with SQL Api and Pervasive SQL7.

But one day Pervasive decided to not support the
SQL Api any more and so with the new release (Pervasive 2000)
they decided to delete the SQL Api.

Now we are obliged to use only Pervasive SQL7 !!!

My applications are a mix of Btrive, SQL Api and
ADO and for this reason I can install only
Pervasive SQL 7.

I'm converting my code to Btrieve but it's a very long deal.

I tried some test to install on the same server
Pervasive SQL8 and Pervasive SQL7 to use the
new Btrieve Engine e the old SQL Api and .....it works !!!

This is what I have done :
1 - Install Win2000 Server
2 - Install Pervasive SQL 8
3 - Install Pervasive SQL 7 (ONLY THE SCALABLE SQL)

Now there are 3 services on the server:
1 - Pervasive SQL (relational)
2 - Pervasive SQL (transactional)
3 - Scalable SQL v4.0 for NT (Server Edition)

My questions are :

1 - How Scalable SQL can access data files ?
It access data files through BTrieve or by
it own way ?

2 - Have you already tried this configuration ?
How much can it be considered stable ?

Thanks
Roberto

 

[mirtheil]

It is not considered stable. Pervasive never tested that configuration. Scalable SQL is basically a Btrieve API app and will be treated like one.
Pervasive.SQL 7 went unsupported Jan 1, 2002 -- three years ago (http://www.pervasive.com/support/lifecycle.asp).
It might work today but I wouldn't trust it.


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

http://www.mirtheil.com