You can use the newer Pervasive SDK (www.pervasive.com), as long as you
stick to the older functions that Btrieve 6.15 supported. There are
very few new functions in PSQL at this level, since the Btrieve API is
pretty full featured to begin with, so this should be only a short leap.

You will then need, though, to change your application from linking
with W3BTRV7.LIB and W3BTRV7.DLL and instead link with WBTRV32.DLL.
The function calls are the same -- it is just a slightly older
interface.

As for price, you can get the SDK for free from Pervasive's web site.
If you want a permanent license of the NEW engine, then it'll cost
under $50, but you don't need it if you retrofit to talk to the Btrieve
6.15 engine instead.

This gives you Btrieve-level access to the files, and you can likely
both read and write. It is fast & flexible, and needs nothing more
than what you have today.

Conversely, you can make it MUCH easier by buying a PSQL workgroup
engine license, copying the data files and DDF's to your local WS, and
then using the newer ODBC drivers to directly extract your data. SQL
is MUCH easier to use, and you can even use other ODBC-compliant
applications to read and write data, including the ETL applications
like Pervasive's Data Integrator or Pentaho (open source). Writing
back will be much more difficult, but if this is not an immediate
requirement, then you'll be OK for a while...
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - March 2008 ***


Gloria wrote:



--