Page 1 of 1

Zeos + PostgreSQL 8 connection problem (D2006)

Posted: 01.03.2007, 23:23
by pendra
Hi

I have a weird problem. I installed Zeos 6.6.1. for Delphi 2006. It was missing some files, so I removed it and installed 6.6.0 instead, which was working fine with MS Access. Now I try to connect to a Postgres server over the internet. It has PostgreSQL 8. I can connect via pgAdmin.
However, if I tried the postgresql-8 protocol, Delphi gives me "none of dynamic libraries can be found: libpq81.dll libpq.dll". I copied the files to system32, to the program's folder etc. None makes a difference.
Then I tried postgresql-7 protocol and then I got a different error:
"SQL error FATAL: No pg_hba.conf entry for host ...". Why do I need that?
I tried just about everything I could think of (except reinstalling XP). Any ideas would be greatly appreciated!

Posted: 02.03.2007, 00:51
by pendra
First time I tell this to myself "search you n00b". Renaming the libpq7.4.dll to libpq.dll helped 50%. And now the weirdest part: I was having this pg_hba.conf error, then I deleted the original ZConnection and added a new ZConnection. Put in the exact same values and it connected without problem.

Posted: 02.03.2007, 06:10
by szoradie
Hello,

Delphi6 search libpq81.dll in Windows\system folder.
If you get other *.dll error message You have to copy there other files.
You can find in C:\Program Files\PostgreSQL\8.1\bin folder.

Ervin,

Posted: 02.03.2007, 09:28
by mdaems
What files where missing for 6.6.1?

Mark