For five years, it worked perfectly. Then one Monday, the chart stopped updating.

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.

On Windows 7 32-bit with PostgreSQL ODBC, the newest driver is not your friend — especially if you have bytea columns or use client-side cursors. Test with 9.0 or 9.2, and always check the 32-bit administrator.