Archive for the ‘BTR2SQL’ Category

Technical FAQ – Btrieve – Microsoft SQL Server

Wednesday, December 16th, 2009

This post is a “living” document – it will be added to over time to provide everything you need to know about administering the Microsoft SQL server to host Btrieve data.
(more…)

Technical FAQ – Btrieve – Oracle

Wednesday, December 16th, 2009

This post is a “living” document – it will be added to over time to provide everything you need to know about administering the Oracle server to host Btrieve data.
(more…)

Testing Btrieve and SQL side by side

Wednesday, December 9th, 2009

The Task

In the initial phases of your evaluation of the Mertech SQL solution, you probably want to compare and contrast your application running against Btrieve and against SQL. Perhaps you want to compare dialogs or reports to ensure the data is all looking the same; or you may want to compare speed.

(more…)

Obtaining The Version Of The Mertech Driver In Use

Monday, November 9th, 2009

When an application has been ported from Btrieve to a SQL backend and the Btrieve access dll (w3btrv7 or wbtrv32) has been replaced, the application does not have any indication the backend has changed.  Perhaps you would like the application to verify which backend is in use or you want to be sure the correct version of the Mertech driver is installed.  This can be done through a standard BTRV function call using B_EXTENDED_VERSION (5026) defined in mds_btrieve.h provided with our driver SDK.
(more…)

Wrong Version Of Btrieve Installed

Friday, November 6th, 2009

Symptoms

When starting an application, it complains that Pervasive.SQL Version XX is not installed or that an old/incorrect version of Pervasive.SQL is installed.
(more…)