Re: ZConnection problems connecting to PostgreSQL
Posted: 10.03.2017, 09:31
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
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