Page 1 of 1

Error on connecting to a PostgreSQL8.1 DB

Posted: 02.02.2006, 13:07
by Stefanie
In an earlier project I used the ZeosLib with PostgreSQL 7 and got no problems at all.
Now I want to use them with PostgreSQL 8.1 with Delphi 7.
On connecting to the database I get an access violation in the libqp8x.dll.

What is wrong?

Posted: 02.02.2006, 15:59
by Stefanie
I tested ZeosLib with MySQL 4.1, everything works fine. This looks as a problem with the PostgreSQL dll.

Posted: 07.02.2006, 09:38
by Michael
Hi Stefanie,

what version of ZeosLib do you use? Maybe try to get the latest from CVS. We changed the driver dlls and also the protocols to support PostgreSQL 8.0 and 8.1 separately. Hope this new version will solve your problems. It runs without problems against my PostgreSQL 8.1 (Delphi 2005 ;-))

Regards.

P.S.: Hope to have more time in the future to create a new CVS-release.

Posted: 07.02.2006, 23:15
by Stefanie
Hi Michael,

first I used the CVS-Release. In the last hours I tried to use the CVS version, but I get new problems.
On connecting to PGSQL 8.1 I get the message "Requested database driver was not found". The libpq81.dll and the libpq.dll are in the same path, as the application.
There is no problem on connecting to the database with the same user, password, database with php or pgAdmin.
The OS is WinXP SP2, IDE is Delphi 7.

Any ideas?

Regards

Stefanie

PS: If I get this thing working, I can do the job with the CVS release.

Posted: 08.02.2006, 06:20
by Michael
Hi Stefanie,

I put the libpq81.dll into the SYSTEM32 folder of my XP-Installation and it works fine. Just tested it, again with protocol "postgresql-8.1". Wonder, what's wrong :gruebel: .

Regards.

Posted: 08.02.2006, 12:26
by vinny
Hi all,

I'm facing the same problem. I try to copy the DLL's to SYSTEM32 directory and receive the access violation message. I also tryed the "rename technic" that I read in another topic, but without success.

[]'s

getting latest version

Posted: 02.03.2006, 15:02
by zydoon
Hi,
I do have the same problem with version zeosdbo-6.5.1-alpha_cvs_13-10-2005, can someone please tell me how to get the latest version from CVS ?
thanks,
Zydoon.

Posted: 04.03.2006, 18:56
by zydoon
Sorry guys,
I got the latest version from CVS.
Now, I copied all the dll (for pgSQL) to windows\system32
delphi complains about not finding libpq81.dll and libpq.dll.
Delphi is correct about libpq.dll it doesn't exist.
can someone help ?

Posted: 04.03.2006, 19:00
by zydoon
Hi again,

i tried to rename libpq8x.dll to libpq.dll, now Delphi sees it ubt bring me back the "access violation" error.
any other suggestion ?

my box : Win XP Home SP2, Delphi 2005 architect update 3, postgreSQL 8.1.3

Posted: 04.03.2006, 19:38
by zydoon
Hi again,
I brought the libpq.dll from postgreSQL\bin directory and renamed it to all sort of libpqXX.dll in vain.
I give up !

Posted: 04.03.2006, 22:48
by btrewern
Try using the 7.4 version of the dll. Has worked for me against 7.4, 8.0 and 8.1 for some time now.

Ben.

Posted: 05.03.2006, 00:57
by zydoon
God Bless you :)
I did what you said.
I renamed the libpq7.4.dll to libpq.dll and now I can connect TZConnection to my latest postgresSQL (8.1.3).

Thank you again.