postgresqldelphipostgresql-13

How to Connect To Delphi 11.3 CE 32 bit With Postgres 16 64 bit?

I am trying to connect to a DB made with Postgres 13. The problem is, Delphi is a 32 bit program and Postgres is 64 bit. Delphi says it needs 32 bit, but there are no 32 bit files for version 16.

I tried the files from version 13, 32 bit but I get the message

"[FireDAC][Phys][PG]-314. Cannot load vendor library [C:\Melvin's Programs\Win32\Debug\New door program\libpq.dll]. Library has unsupported architecture [x64]. Required [x86]. %1 is not a valid Win32 application Hint: check it is in the PATH or application EXE directories, and has x86 bitness.."

Edit

I was incorrect. The DB was made in Postgres 13. I previously stated that it was v16. Both are 64 bit.

Solution

  • I have a 64 bits Postgresql running and my aplication is a 32 bits.

    You have to use the 32bit version of libpq.dll