- In most cases, you will need to have an ODBC Connection for PostgreSQL. If you are working with GIS software, mostly you will need to have a ODBC Connection. In this article, I am going to guide you how to create a PostgreSQL ODBC connection in Windows 10.
- By default, Windows 10 does not shipped with Oracle ODBC connection utility. In other word, I was unable to connect to my Oracle database from MS Access. Installing Oracle ODBC Driver on Windows 10 is a bit tricky. It’s not as simple as installing PostgreSQL ODBC driver or MySQL ODBC Driver. I was struggling to get it works.
- Dec 26, 2018 This article explains how to connect to PostgreSQL with the official PostgreSQL ODBC driver psqlodbc, when using Windows 10. It covers how to connect to postrgreSQL (with code samples), and how to setup ODBC.
- The ODBC Driver for PostgreSQL download page. We use cookies to provide you with a better experience on the Devart website.
- The PostgreSQL installers created by EnterpriseDB are designed to make it quick and simple to install PostgreSQL as a GUI on your computer. The installer provides: Install PostgreSQL 10 in windows.
- Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from Windows, Linux and Mac OS X, both.
I have the latest 64 bit version of PostgreSQL. I am running Win 7 64 bit. I had installed the ODBC driver (via the initial installer) when I installed PG, and upgraded it to the latest version from http://www.postgresql.org/ftp/odbc/versions/msi/.
However, when I go to the ODBC control panel and try to add a User DSN, PostgreSQL isn't listed as a server.
I was following the instructions given here, but I noted the links are dated.
Connect to PostgreSQL with the PostgreSQL ODBC driver (psqlODBC) ODBC drivers aren't listed in the drop-down list of data sources. To connect with an ODBC driver, start by selecting the.NET Framework Data Provider for ODBC as the data source on the Choose a Data Source or Choose a Destination page.
IamICIamIC4 Answers
As I see PostgreSQL installer doesn't include 64 bit version of ODBC driver, which is necessary in your case. Download psqlodbc_09_00_0310-x64.zip and install it instead. I checked that on Win 7 64 bit and PostgreSQL 9.0.4 64 bit and it looks ok:
Test connection:
Grzegorz SzpetkowskiGrzegorz SzpetkowskiInstalling psqlODBC on 64bit Windows
Though you can install 32 bit ODBC drivers on Win X64 as usual, you can't configure 32-bit DSNs via ordinary control panel or ODBC datasource administrator.
How to configure 32 bit ODBC drivers on Win x64
Configure ODBC DSN from %SystemRoot%syswow64odbcad32.exe
- Start > Run
- Enter:
%SystemRoot%syswow64odbcad32.exe - Hit return.
- Open up ODBC and select under the System DSN tab.
- Select PostgreSQL Unicode
You may have to play with it and try different scenarios, think outside-the-box, remember this is open source.
mivkPlease note that you must install the driver for the version of your software client(MS access) not the version of the OS.that's mean that if your MS Access is a 32-bits version,you must install a 32-bit odbc driver.regards
First you download ODBC driver psqlodbc_09_01_0200-x64.zip then you installed it.After that go to START->Program->Administrative tools then you select Data Source ODBC then you double click on the same after that you select PostgreSQL 30 then you select configure then you provide proper details such as db name user Id host name password of the same database in this way you will configured your DSN connection.After That you will check SSL should be allow .
Then you go on next tab system DSN then you select ADD tabthen select postgreSQL_ANSI_64X ODBC after you that you have created PostgreSQL ODBC connection.
protected by Community♦Jul 17 '15 at 21:20
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?