ZConnection problems connecting to PostgreSQL

[EgonHugeist]

Hello JD,

sorry for my absence.
The problem is simple to me. You're in trouble with the locations of the PG-libraries on your computer.
Loads of users did point you to the solution. Last error shows you've mixed some incompatible pg-libs inbetween.

Clean up your computer, please.
May i ask the Compile target of your LazarusIDE? As you say all is 32Bit (compile target of you Application and PostgreSQL -> that's way Runtime works). The IDE too? If LCL is running in 64Bit and you try to connect to a 32Bit lib you'll allways fail @desingtime.
Keep track the lib's can be found @runtime and designtime.
Follow miab3 suggestions with the SysWOW64 vs System32 paths in \Windows directory.

In addition: if one of the suggested libs of pg is 64 bit all other loading will fail too. The lib loading doesn't tell zeos which load did fail. Just "Hello, i was able to find a library somewhere on your harddist. But on getting the handles something went wrong".

Make a fresh environment on a vm f.e. test everything again ... you'll succeed.

Finally use current trunk or testing branches from SVN to be on same bandwidth and using mORMot of course.

Michael

[janneta]

Hi
I had this problem few times on few machines and configurations.

All solutions above are correct but sometimes you need to do this extra step to get this working as you need msvcr120.dll in your system to get DLL's that working (msvcr120.dll is used by pqlib.dll)
Without this DLL you will get error msg you have. I just spent hours to find this sollution. Hope it helps

Solution :

Install VCRedits 2013 x86 version from Microsoft:
https://support.microsoft.com/pl-pl/hel ... le-package

Good luck