I have installed the ODBC driver on Windows XP Professional 64bit. The installation said that it was sucessful, but I cannot see the odbc driver in the ODBC data sources administrator. Is there something that I have to do on Windows 64 bit to use the driver? Download trial version of ODBC PostgreSQL Connector for Windows 64-bit and test a unique data connectivity solution used by enterprises worldwide.
From Devart: 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 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with PostgreSQL fast, easy and extremely handy. Key Features: - Direct Connection. Database applications based on our solution get an opportunity to establish connection to PostgreSQL in Direct Mode. Direct Mode gives your applications an unrivalled advantage - connection to PostgreSQL databases directly via TCP/IP avoiding PostgreSQL Client. That improves performance of your applications, their quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application. - Secure connection support via SSH protocol, SSL protocol and HTTP tunnel. - Development Platforms Variety. ODBC driver for PostgreSQL doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows, Linux and Mac OS X, both 32-bit and 64-bit. - ODBC Conformance. Our ODBC driver provides full support for common ODBC interface: * ODBC Data Types support * ODBC API Functions support In addition, we provide support for Advanced Connection String parameters. Thus allowing any desktop and web applications to connect to PostgreSQL from various environments and platforms, that support ODBC. - DB Compatibility. Our driver is compatible with major and the latest PostgreSQL server versions since 7.1 up to 9.2. - Microsoft Power BI Desktop and Microsoft Visual FoxPro compatibility. - Improved compatibility with MS Visual Studio, MS Fox Pro, MapInfo, Libre Office, Qlik, Delphi & C++Builder, MS Access.
What do you need to know about free software?
From Devart: 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 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with PostgreSQL fast, easy and extremely handy. Key Features: - Direct Connection. Database applications based on our solution get an opportunity to establish connection to PostgreSQL in Direct Mode. Direct Mode gives your applications an unrivalled advantage - connection to PostgreSQL databases directly via TCP/IP avoiding PostgreSQL Client. That improves performance of your applications, their quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application. - Secure connection support via SSH protocol, SSL protocol and HTTP tunnel. - Development Platforms Variety. ODBC driver for PostgreSQL doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows, Linux and Mac OS X, both 32-bit and 64-bit. - ODBC Conformance. Our ODBC driver provides full support for common ODBC interface: * ODBC Data Types support * ODBC API Functions support In addition, we provide support for Advanced Connection String parameters. Thus allowing any desktop and web applications to connect to PostgreSQL from various environments and platforms, that support ODBC. - DB Compatibility. Our driver is compatible with major and the latest PostgreSQL server versions since 7.1 up to 9.2. - Microsoft Power BI Desktop and Microsoft Visual FoxPro compatibility. - Improved compatibility with MS Visual Studio, MS Fox Pro, MapInfo, Libre Office, Qlik, Delphi & C++Builder, MS Access.
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.
IamIC
IamIC8,0591616 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 Szpetkowski
Grzegorz 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.
mivk
6,91822 gold badges4141 silver badges4545 bronze badges
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.
Driver Odbc Postgres Windows 7 64 Bits
RushikeshRushikesh
protected by Community♦Jul 17 '15 at 21:20
Odbc Postgresql Windows 64 Bits Est Requis
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?
Postgresql Odbc Download
Not the answer you're looking for? Browse other questions tagged postgresqlodbcdatabase-connectiondriver or ask your own question.