error connecting to postgresql
lazarus / 16-Databases

----------------------------------------------------------------------
crixtiano · 2019-12-11 21:30

When trying to connect to PostgreSQL using the TPQConnection object,
the error occurs:

"Can not load PostgreSQL client library "libpq.dll". Check your
installation."

(see attached image)

Versions:

PC (Server DB):
    Postgres 10.10
    Ubuntu 18.04.3 LTS 32 bits
    (database access successfully tested with pgAdmin 4)

PC with Lazarus
    Lazarus
        Version 2.02
        Date: 2019-04-13
        FPC version: 3.0.4
        SVN: 60954
        x86_64-win64-win32/win64
    Windows 8 64 bits


Does anyone know how to solve this?

Thank you.

Cristiano M. Magalhaes

----------------------------------------------------------------------
Miflon · 2019-12-12 07:40

Hi crixtiano.
That situation was faced by me few months ago when I installed
wappstack-7.3.11-0 for a local use. You need the following 5 dll files
libeay32.dll,libiconv-2.dll,libintl-8.dll,libpq.dll
andssleay32.dll.All of them must be 64 bits. You can use Dependency
Walker to test. These files must be placed in "C:\Windows\System32\"
directory.
For me libpq.dll from Postgresql did not work. I was forced to use a
former libpq.dll from an older install. Here are  the properties of
the 5 files:
libeay32.dll:version 1.0.2.10; date: 04/11/2019libiconv-2.dll:version
1.16.0.0; date: 04/11/2019libintl-8.dll:version 0.1.20.0; date:
03/11/2019libpq.dll:version 9.6.3.17128; date: 14/07/2017
andssleay32.dll:version 1.0.2.10; date: 04/11/2019It's the first time
I help somebody so I post under the watchfull eyes of the experts of
this forum.
Michel.

----------------------------------------------------------------------
MarkMLl · 2019-12-12 08:27

Quote from: Miflon on December 12, 2019, 08:40:07 amIt's the first
time I help somebody so I post under the watchfull eyes of the experts
of this forum.
Michel.

You're doing fine, but I think the best answer would be "For Windows 8
you're going to need the PostgreSQL client bundle from here".

It's a very long time since I've had to do this for Windows, but I've
certainly seen that sort of thing from Postgres in the past:
installers which were very picky about what version of OS they'd run
under (even if the payload was far more tolerant) and so on.

MarkMLl

----------------------------------------------------------------------
darksoft · 2019-12-20 14:33

You can also put them in your application directory.

----------------------------------------------------------------------
crixtiano · 2020-01-17 19:28

Quote from: Miflon on December 12, 2019, 08:40:07 am
libeay32.dll,libiconv-2.dll,libintl-8.dll,libpq.dll
andssleay32.dll.All of them must be 64 bits. You can use Dependency
Walker to test.

Please, where can I download these dll files?

Where do these DLLs come from? What program do they belong to?

Thank you!

Cristiano M. Magalhaes