PostgresSQL offers both 64-bit and 32-bit odbc drivers.
The app may need an 64-bit odbc driver, see if you can download that
http://www.datadirect.com/products/odbc/postgresql/index.html
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Della-Croce, Gregory
Sent: Saturday, June 09, 2012 4:10 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010
· Ok I feel like a bit of a rubber ball. Microsoft saw this question and said “Great question go ask customer support at PostgreSQL. All I want is a simple answer to what I thought was a simple answer.
- I have a remote PostgreSQL 8.4 database backing up my clients application.
- I have created (having to go in as ADMINISTRATOR) ODBCAD32 for 64bit both User and System drivers on my computer.
- I went to Access 2010 on my computer, opened a database, went to External Data ODBC Database. I expected to see my drivers listed there. They were not. Only the standard 32bit drivers where listed.
MY QUESTION: How do I get to the drivers to get to the database to get to the data to write the application reports that the client needs?
Please Note: I have done some programming in Access but I am rusty. I do not have access to VS.NET, so it will have to be VBA code. I am running a Win 7 64bit system with a special read-only Network connection to the database. I can see the database on with the pgADMIN III tool. That provided a place for the connection to be record directly and did not ask for the ODBC Drivers.
I am grateful to any and all I hear from with a working solution. Please unless the link is better than the How to that I saw please be more specific.
Greg Della-Croce
Applications Administrator