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

Question

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.

Answer 1

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

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

Answer 2

The path was incorrect. It seems it defaulted to a previous path. A TFDPhysDriverLink with the venderlib property set to the correct path with the correct files solved the problem. Thanks everyone for all your time!