Postgresql Odbc Driver Windows 7 32 Bit Better -
PostgreSQL does not include the ODBC driver in the standard database installation; it must be installed separately.
On Windows 7, there are two different ODBC Administrator tools. This is where many users encounter failure. postgresql odbc driver windows 7 32 bit
The Excel VBA code was using ADODB.Connection and setting CursorLocation = adUseClient . The PostgreSQL 32-bit ODBC driver, version 9.3+ on Windows 7, had a known but rarely documented bug: when adUseClient was set before opening the connection, the driver failed to negotiate the bytea type mapping correctly with the 32-bit PostgreSQL client library — especially if any column in the queried table was type bytea (even if not selected). The driver would throw a generic -2147467259 instead of a meaningful error. PostgreSQL does not include the ODBC driver in
: Right-click the downloaded .zip file and extract the .msi installer. Run the Installer : Double-click the .msi file. The Excel VBA code was using ADODB