The standard solution is the PostgreSQL ODBC driver (psqlODBC). However, many users run into a specific hurdle: . If your legacy application doesn't understand Unicode, the standard 64-bit driver won't work. You need the PostgreSQL ANSI ODBC Driver .
Here is everything you need to know to get this working on Windows 7. Modern Windows applications use UTF-16 (Unicode). PostgreSQL drivers default to this. However, older applications (often built with Visual Basic 6, older C++, or Delphi) were compiled for ANSI (code pages like Windows-1252). postgresql ansi odbc driver windows 7
If you try to use the standard Unicode driver with these old apps, you’ll likely see garbled text ( ???? ), truncated strings, or the driver simply failing to appear in the ODBC Data Source Administrator list. The standard solution is the PostgreSQL ODBC driver