Use Test button in the DSN dialog. If it fails, check that PostgreSQL’s pg_hba.conf allows connections from your Windows 7 IP.
This article explores how to set up, configure, and troubleshoot the PostgreSQL ODBC driver on Windows 7, ensuring seamless data connectivity between legacy Microsoft tools and powerful open-source databases. odbc driver for postgresql for windows 7
If installation fails, try running the .msi installer as an Administrator. Use Test button in the DSN dialog
The official driver for PostgreSQL is called . It is open-source and maintained by the PostgreSQL Global Development Group. odbc driver for postgresql for windows 7