-->APPLIES TO: SQL Server, including on Linux Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
This topic shows you how to connect to a PostgreSQL data source from the Choose a Data Source or Choose a Destination page of the SQL Server Import and Export Wizard.
Download Postgresql Odbc Driver Windows 10
Compiling psqlODBC on Windows. This page describes how to build the PostgreSQL ODBC Driver on Windows. There are three methods to build: from command line using nmake makefiles, from Powershell using MSBuild files, and from Visual Studio IDE.
- I've been looking at this some more, and unfortunately it looks like psqlODBC will not work on 64 bit versions of Windows at present. The reason that you do not see the driver is because the installer (being 32 bit) installs the ODBC registry keys under HKEYLOCALMACHINE SOFTWARE Wow6432Node ODBC instead of HKEYLOCALMACHINE SOFTWARE ODBC.
- PostgreSQL 64-bit is a powerful object-relational database management system! Download PostgreSQL Offline Installer Setup 64bit for PC! It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).
Important
The detailed requirements and prerequisites for connecting to a PostgreSQL database are beyond the scope of this Microsoft article. This article assumes that you already have PostgreSQL client software installed and that you can already connect successfully to the target PostgreSQL database. For more info, consult your PostgreSQL database administrator or the PostgreSQL documentation.
Get the PostgreSQL ODBC driver
Install the ODBC driver with Stack Builder
Run Stack Builder to add the PostgreSQL ODBC driver (psqlODBC) to your installation of PostgreSQL.
Or, download the latest ODBC driver
Or, download the Windows installer for the latest version of the PostgreSQL ODBC driver (psqlODBC) directly from this FTP site - https://www.postgresql.org/ftp/odbc/versions/msi/. Extract the files from the .zip file and run the .msi file.
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. This provider acts as a wrapper around the ODBC driver.
Here's the generic screen that you see immediately after selecting the .NET Framework Data Provider for ODBC.
Options to specify (PostgreSQL ODBC driver)
Note
The connection options for this data provider and ODBC driver are the same whether PostgreSQL is your source or your destination. That is, the options you see are the same on both the Choose a Data Source and the Choose a Destination pages of the wizard.
To connect to PostgreSQL with the PostgreSQL ODBC driver, assemble a connection string that includes the following settings and their values. The format of a complete connection string immediately follows the list of settings.
Tip
Get help assembling a connection string that's just right. Or, instead of providing a connection string, provide an existing DSN (data source name) or create a new one. For more info about these options, see Connect to an ODBC Data Source.
Driver
The name of the ODBC driver - either PostgreSQL ODBC Driver(UNICODE) or PostgreSQL ODBC Driver(ANSI).
The name of the ODBC driver - either PostgreSQL ODBC Driver(UNICODE) or PostgreSQL ODBC Driver(ANSI).
Server
The name of the PostgreSQL server.
The name of the PostgreSQL server.
Port
The port to use to connect to the PostgreSQL server.
The port to use to connect to the PostgreSQL server.
Disk drill activation code mac. Database
The name of the PostgreSQL database.
The name of the PostgreSQL database.
Uid and Pwd
The Uid (user id) and Pwd (password) to connect.
The Uid (user id) and Pwd (password) to connect.
Connection string format
Here's the format of a typical connection string.
Enter the connection string
Enter the connection string in the ConnectionString field, or enter the DSN name in the Dsn field, on the Choose a Data Source or Choose a Destination page. After you enter the connection string, the wizard parses the string and displays the individual properties and their values in the list.
The following example uses this connection string.
Here's the screen that you see after entering the connection string.
Other data providers and more info
For info about how to connect to PostgreSQL with a data provider that's not listed here, see PostgreSQL connection strings. This third-party site also contains more info about the data providers and the connection parameters described on this page.
See also
Choose a Data Source
Choose a Destination
Choose a Destination
Active3 years, 6 months ago
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.
IamICIamIC8,0691616 gold badges7575 silver badges128128 bronze badges
4 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 Szpetkowski31.4k44 gold badges7272 silver badges117117 bronze badges
Installing 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.
mivk6,91822 gold badges4141 silver badges4545 bronze badges
Postgresql Odbc Driver Install
TSMurphyTSMurphy
Please 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
PatrickPatrick
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.
RushikeshRushikesh
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?
Would you like to answer one of these unanswered questions instead?