Ensure your PostgreSQL server is configured to allow remote connections in the pg_hba.conf file and that the Windows 7 firewall isn't blocking port 5432.
Follow the installation wizard. In most cases, the default settings are sufficient. The installer will register the necessary DLL files with the Windows Registry, making them available to the . 4. Configuring the Data Source (DSN)
Click → If successful, click Save .
Select the tab (this makes the connection available to all users on the PC). Click Add .
You need to know if your Windows 7 is or 64-bit . install postgresql odbc driver windows 7
Open :
Driver=PostgreSQL Unicode;Server=127.0.0.1;Port=5432;Database=mydb;Uid=postgres;Pwd=secret; Ensure your PostgreSQL server is configured to allow
You must run the specific 32-bit tool located at C:\Windows\SysWOW64\odbcad32.exe . Using the standard tool will not show your 32-bit driver. Add a New Source: