Zeos + PostgreSQL 8 connection problem (D2006)

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
pendra
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 01.03.2007, 22:35

Zeos + PostgreSQL 8 connection problem (D2006)

Post 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!
pendra
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 01.03.2007, 22:35

Post 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.
szoradie
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 23.02.2007, 20:46

Post 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,
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

What files where missing for 6.6.1?

Mark
Post Reply