Skip to the main content.
Downloads Try Thriftly
Downloads Try Thriftly
Group 762

Migrate and run DataFlex applications with Oracle, MS SQL Server, PostgreSQL, MySQL &  MariaDB.

flex2Crystal

Stuck in Crystal XI?  Upgrade and use the latest versions of Crystal Reports with DataFlex applications. 

BTR2SQL

Convert from Btrieve / P.SQL / Actian transactional engines to Oracle, MS SQL Server, and PostgreSQL

thriftly-1

Quickly build multi-protocol web services with the same API. Supports JSON-RPC, REST, SOAP,  Thrift, and gRPC.

 Group 671-1

 

Why Mertech?

1 min read

Status 8020 With Pervasive.SQL V10

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.

 

Download My BTR2SQL Whitepaper

 

Hybrid Cloud Migration: Plan, Process and Advantages

Hybrid Cloud Migration: Plan, Process and Advantages

This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.

Read More
Financial Benefits of Cloud Migration & Hybrid Cloud Applications

Financial Benefits of Cloud Migration & Hybrid Cloud Applications

Shifting from your traditional legacy systems to the Cloud can be a game changer, as the benefits of cloud migration are numerous. Cloud computing...

Read More

AWS Application Modernization: Best Practices & Tools

In the age of digital transformation, businesses are increasingly moving away from traditional on-premises systems, steering towards more dynamic,...

Read More