But the connection failed even with the 32-bit driver. I ran psql from the same machine — worked perfectly. Firewall, network, credentials — all fine.
If you install the 64-bit driver because your OS is 64-bit, the application will not be able to see or utilize the driver. postgresql odbc driver windows 7 32 bit
I applied these changes, rebooted the Windows 7 machine (it was that sensitive), and the macro ran perfectly again. But the connection failed even with the 32-bit driver