Error: Unable to load the FDO provider library postgresqlprovider.dll

[enricolochi]

Hello everyone!
I created a postGIS database on a server called "aisrv2" on the standard port 5432.
Connecting from QGIS the connection works, so I wanted to do the same in Civil 3d 2023
through the tool 'Add PostgreSQL Connection' in Map Connect Menu, but I get the error
"Unable to load the FDO Provider library ‘PostgreSQLProvider.dll'.
As I read on Autodesk support here
I set the service parameters as shown in the image and copied the file libpq.dll
from the server to the specified path (in my case I don't have the files libeay32 and ssleay32.dll).
But I always get the same error.
I'm using postgreSQL v.15 (x64) on a Windows Server 2012R2



Could anyone suggest me what to try to fix the error?
Thanks everyone!

[ftatulli]

i am too interested about this topic, the official documentation is very little

[JensClassen]

Same problem here with PostgreSQL 12

[retno_utami]

Hi,

this are the answers from PostgreSQL forum regarding the missing files: libeay32 and ssleay32.dll are the libraries names for OpenSSL 1.0.2 and no longer used by PostgreSQL windows installers. They use OpenSSL 3.0 and the library names for those 2 DLLs would be libssl-3-x64.dll and libcrypto-3-x64.dll and present in $installdir/bin/ directory

Hope that helps.