The VBA macro threw error -2147467259 (Unspecified error) at the conn.Open line. The data source name (DSN) was configured in User DSN using the PostgreSQL ANSI(x64) driver. Except… Windows 7 32-bit doesn’t have an x64 driver. That was my first clue something was very wrong.
For five years, it worked perfectly. Then one Monday, the chart stopped updating. postgresql odbc driver windows 7 32 bit
It was 2018, and I was maintaining a legacy production line reporting system for a mid-sized manufacturing plant. The core database was PostgreSQL 9.6 running on a Linux server. The front-end was a vintage Windows 7 Professional 32-bit machine in the quality control lab. On this machine ran an ancient Excel 2010 VBA macro that pulled defect data every 15 minutes, generated charts, and printed them to a network label printer. The VBA macro threw error -2147467259 (Unspecified error)
I documented the fix in a Word doc on the desktop and locked the driver version. The system ran until 2020, when Windows 7 was finally retired and the plant upgraded to Windows 10 LTSC — using the same 32-bit ODBC driver in compatibility mode. That was my first clue something was very wrong