Flex2SQL error accessing the PostgreSQL server

Here's how to proceed if you get a message stating "Unable to load the MDSPGSQL driver. Please check that you installed the client library and that the driver can be found."

Problem

An error message displays when trying to access the PostgreSQL server:

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 FLEX2SQL 12.1 and above, the dlls should already be available for the Migration tool and installed in 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

For earlier releases, contact Mertech technical support for the required dlls.