Windows

Windows: Set up PostgreSQL ODBC Data Source

Share on reddit
Share on LinkedIn
Bookmark this on Hatena Bookmark
Bookmark this on Google Bookmarks

Here is the way to set up PostgreSQL ODBC Data Source in Windows.

Environment

  • Windows 10 64-bit

Procedure

Install ODBC Driver

  1. Download and install PostgreSQL ODBC Driver. It’s on the page of PostgreSQL. This time I chose 32-bit version, psqlodbc_09_05_0400-x86.zip.
  2. Open the zip file and execute msi installer in it. The driver will be installed

Add ODBC DataSource

  1. Open control panel. (Type Windows Key and R, and input “control” and press Enter key.)
  2. Press Ctrl and F, then type “odbc” to filter the items.
  3. This time I used 32-bit driver, so click “Set up ODBC data sources (32-bit)”.
  5. Click “Add” on the dialog to add new connection to PostgreSQL.
  6. After the dialog for adding data source appears, then choose “PostgreSQL Unicode” and click “Finish”.
  7. Fill the form of connection information. When you click Test button, form value will be tested.
    • Data Source: the name of connection. You can define it freely.
    • Description
    • Database: Database name
    • SSL Mode: recommend “allow”
    • Server: server host name or ip address
    • Port: 5432 in usual
    • User Name
    • Password
  8. Click Save, then new PostgreSQL ODBC data source will be created.

Related Posts

Readers who viewed this page, also viewed:

Share on reddit
Share on LinkedIn
Bookmark this on Hatena Bookmark
Bookmark this on Google Bookmarks