Re: connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010

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

Thanks
Barry Bell, IT Department
Office: 954-429-3771 x267 Fax: 954-281-1464 email Barry_Bell(at)harte-hanks(dot)com<mailto:Barry_Bell(at)harte-hanks(dot)com>

From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Della-Croce, Gregory
Sent: Saturday, June 09, 2012 4:10 PM
To: pgsql-odbc(at)postgresql(dot)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