PCL is a set of DLLs that expose the same functions as the Pervasive DLLs, moreover they are able to transform the API calls (Scalable SQL and BTrieve) into SQL Command to use with an ODBC connection.
Here in Info-Bit we had two problems :
1 - we were obliged to use only Pervasive SQL.7 because we had about 500.000+ lines of VB6 code written using Scalable SQL API (xFetch, XQLCompile, xUpdate, xInsert, xCursor, etc..)
2 - we were obliged to use Pervasive SQL Engine because we had about 3.500.000+ lines of VB6 code written using BTRIEVE API (BtrCall)
It was impossible for us to re-write all our lines of code so we started thinking of a way to change database rewriting as less lines of code as possible ... and we achieved it !!!
We developed a set of DLLs that expose the same functions as the Pervasive DLLs, moreover they are able to transform the API calls (SSQL and BTrieve) into SQL Command to use with an ODBC connection.
In 3 days, we were able to convert all our code and to run our programs using any other SQL engine with an ODBC connection ... manually changing only few lines of code.
Now we are able to run our programs on Pervasive SQL.10 or on any other SQL engine.
We called the result of our job PCL (Pervasive Conversione Library) and we also developed a program that is able to automatically modify the few lines of code that need to be changed.
In line with this, we offer our technical know-how to everybody who is experiencing the same problems that we had.
We can help you to solve your problems with our PCL DLLs.