BTR2SQL error accessing the PostgreSQL server v 9.1, v 9.2 and v 9.3

Problem

An error message displays trying to access the PostgreSQL server v 9.1, v 9.2 and v 9.3:

Cause

Typically this problem is caused by missing dependencies for the PostgreSQL client library:

• Common Windows dlls: msvcr71.dll, msvcr80.dll, comerr32.dll

• Kerberos Support: gssapi32.dll, k5sprt32.dll, krb5_32.dll

• SSL: libeay32.dll, libiconv-2.dll, libintl-8.dll, ssleay32.dll

• PostgreSQL library itself: libpq.dll

Solution

For BTR2SQL v5, the required files are installed in the folder <ProgramFiles(x86)>Mertech Data Systems\DB Drivers\Btrieve\clients\pgsql. Copy the files to the <winsys32> directory.

Depending on whether you are running on a 32–bit computer or on a 64–bit computer, the <winsys32> variable is resolved as:

• 32–bit: <windir>\system32

• 64–bit: <windir>\sysWOW64

Earlier versions of BTR2SQL, contact Mertech technical support to obtain the dlls.