Autor: Fernando Rafael Filipuzzi
E-mail: fernando_6867@yahoo.com.ar
He tenido algunos problemas de dlls en windows (libpq.dll y otros). La solución fue dada en: link, donde dice;
Hello.
If you are using PostgreSQL as localhost (PostgreSQL installed on your computer), then you don't need to copy content of PostgreSQL bin folder to your project folder.
Instead, you just need to set Windows environmental variable called Path, to include path to the PostgreSQL "bin" folder. Bin containes all libraries and programs.
You do it the following way:
Right click on "My Computer" icon, chooce "Properties" then go to "Advance" tab. There you click "Environmental variables" button. Then you find list "System variables". Find variable "Path" in the list. Go to Edit. There you append the following string in the "Variable value": "C:\Program Files\PostgreSQL\8.1\bin;", assuming that you have PostgreSQL 8.1.X installed.
If you entered this string correctly, your .exe will now know where PostgreSQL client libraries reside, and it will work.
I think it is generally the better way to deploy just .exe, not client libraries, because you can't know which PostgreSQL server version will be installed on the user's computer.
Regards,
Zlatko
Haciendo click derecho en "MI PC" y propiedades, luego de un pantallazo tenemos:
En mi caso, le agregué:
Puede que halla un problema de "root.crt" al activar el PQConnection
Se puede agregar una variable de sistema: