Skip to content

Microsoft Access PostgreSQL driver

Nassib Nassar edited this page Jun 5, 2020 · 1 revision

Installing a PostgreSQL ODBC driver

First, make sure your Windows machine has the right driver to connect to a PostgreSQL database. This is an ODBC driver that is tailored to PostgreSQL, and PostgreSQL shares ODBC drivers that can be installed a variety of ways.

  1. It is recommended to use the MSI (Microsoft Installer) version of the ODBC driver installer.
  2. On this page, scroll all the way down to find the latest versions of the driver.
  3. For each PostgreSQL version (e.g., 12.0.0), you'll see three files: a plain .zip file, then one that ends with x86 and another that ends with x64. The plain .zip contains a .exe file, but using this file doesn't seem to work well. It is recommended to use the x64 file if you have a 64-bit Windows machine and the x86 file if you have a 32-bit Windows machine.
  4. If you don't know if you have 32-bit or 64-bit Windows, go to your Windows settings and look for "About this PC". You should see something like "System type", which should say 32-bit or 64-bit. Most machines these days are 64-bit.
  5. Download the right .zip file, then extract the contents to get to the .msi file
  6. Run the .msi file to install the drivers