Hybrid Cloud Migration: Plan, Process and Advantages
This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.
Symptoms
An application reports a Btrieve status 8020. Pervasive.SQL version 10 or above is installed.
Cause
The application shipped with an older version of the Btrieve access dll (W3BTRV7.dll or WBTRV32.dll). This dll is no longer compatible with later versions of PSQL.
The Windows file properties can reveal the version of the dll (in the Version tab). The size of the dll is also fairly conclusive. The version 9 dlls are 42k. Version 10 dlls are 32k.
Resolution
The access dll in use must match the version of the database engine. Using Windows Explorer, Search the entire computer for "w3btrv7.dll wbtrv32.dll". You should find the version 10 dlls in the installation folder for Pervasive.SQL. You will find the 45k version of the dlls in other locations - most likely in the folder with the application executable. For instance, you will find the 45k version in <program files>Mertech Data SystemsDB DriversBtrievebin.
Note, you will also find larger sized versions (800k or more) in the Mertech folder. These are the replacement dlls which allow access to the SQL server of your choice.
Delete all of the 45k versions of the dlls. The 32k versions shipped with V10 should be on the system PATH and thus be found by the application.
Learn how we can help you easily migrate from Btrieve to SQL without any costly code changes by reading our free whitepaper.
This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.
Shifting from your traditional legacy systems to the Cloud can be a game changer, as the benefits of cloud migration are numerous. Cloud computing...
In the age of digital transformation, businesses are increasingly moving away from traditional on-premises systems, steering towards more dynamic,...