Mertech BTR2SQL Tech Blog

How to run a DOS Btrieve application with a SQL server

thomaso — Wed, 19 Jan 2011 17:13:15 +0000

There are still plenty of DOS-based Btrieve applications in use today. Is it possible to move these applications to a current SQL server to take advantage of integration with other applications and powerful data management tools? The Mertech BTR2SQL driver is a replacement for the Btrieve interface. As noted in the white papers and documentation, the [...]

Connecting to an Oracle Database

thomaso — Mon, 25 Oct 2010 15:52:59 +0000

Question What do I input for the “server name” in the login dialog? Using the “easy connect” naming method ( Information copied from http://download.oracle.com/docs/cd/B28359_01/server.111/b28301/network004.htm ) The easy connect naming method provides TCP/IP connectivity to databases without the need to first configure Oracle Net Services. The connect identifier has the following format: “[//]host[:port]/service_name” where: host is the name or IP address of the [...]

Writing 64-bit applications?

gandalf — Mon, 27 Sep 2010 20:50:26 +0000

We now provide 64-bit versions of our BTR2SQL drivers, to allow you to take advantage of the greater address space that comes with working with 64 bits. The new driver name is ‘w64btr.dll’ in following with Pervasive’s naming convention. Deployment is the same as always. Copy the driver and your license file into your application bin [...]

How to troubleshoot “Error loading driver!”

thomaso — Wed, 09 Jun 2010 06:04:40 +0000

The Error When starting the Btr2SQL migration tool, you receive an message in the login dialog saying “Error loading driver!”. The Cause The “driver” for the migration tool is one of three dlls: sql_btr.dll, ora_btr.dll or mys_btr.dll found in the bin folder of the installation (usually \Mertech Data Systems\DB Drivers\Btrieve\bin). As noted in the user manual, each of [...]

How do I re-enable the login dialog?

thomaso — Thu, 17 Dec 2009 00:30:39 +0000

Question When I first launch our application, a dialog asks me for the database/password. I clicked the box to save these results and not prompt the next time. How do I get it to prompt me again? Answer The login information is stored in the registry. A value named SavePassword stores a ‘1′ for Remember Password and a ‘2′ for [...]