How to fix Status 8020 error with Pervasive.SQL v10 and above

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.