Firedac Connection with Postgresql DLL Error

Asked

Viewed 6,801 times

3

I’m with DLL error not found when making a connection to Postgresql using the Firedac component.

Error:

[Firedac][Phys][PG]-314. Cannot load vendor library [C: EXE libpq.dll]. Hint: check it is in the PATH or application EXE Directories, and has x86 bitness.

The detail is that I already copied the DLL to the application directory, also to test copied the dll to System32 and Syswow64, but the error persists.

I have Microsoft C++ package 2015 installed, as requested in the documentation of Embarcadero: Wiki Embarcadero

Another test I performed was for the Firedac component to try to make the connection, including in the Postgres drive I pointed the Vendorlib property to the DLL, but again the same error.

Does anyone have any other suggestions? Grateful from now on.

delphi postgresql dll firedac

  • Other information that can help: the application was developed on 32bit platform, so I installed postgree x32/x86

  • Install Postgresql x64 and see if the problem persists.

3 answers

4


To everyone’s knowledge, the problem has been solved. For Postgresql to work properly it is necessary to copy the following Dlls to the application folder:

  • Libeay32.dll
  • Ssleay32.dll
  • Intl.dll
  • Libpq.dll

Copy these Dlls from the Postgresql installation bin directory.

  • x64: libcrypto-1_1-x64.dll, libintl-8.dll, libpq.dll, libssl-1_1-x64.dll, msvcr120.dll

0

In my case, the problem was solved when I added Object Inspector Fdphyspgdriverlink1 to the Form. On the Vendorhome property, you get a directory, I delete the lib, and that’s it. It worked normally after I did that.

0

I know your problem has already been solved, but I would like to leave my contribution to others..

I recommend downloading these dll and putting it in the folder of the executable under production, on the x86 platform, because the default executables in Delphi is 32bis

on the official website https://www.postgresql.org/ftp/odbc/versions/dll/

Browser other questions tagged delphi postgresql dll firedac

You are not signed in. Login or sign up in order to post.