Re: connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010
Della-Croce, Gregory <Greg_Della-Croce <at> wycliffe.org>
2012-06-10 02:16:39 GMT
Thanks for being someone who answered. I am saying that I do not see the ODBC drivers for PostgreSQL at all. I
only see the standard set (dBase, Access, ... ). Ya it is confusing, ODBCAD32 is the name for both the 64 and
32 bit drivers. I all depends on which Windows lib you are looking in at the time. I did use the file you
mentioned (psqlodbc_09_01_0100-x64.zip) and that is what I installed using ODBCAD32.exe/run as
Administrator. If you do not run it as Administrator you end up only seeing the 32bit drivers.
So the problem is getting the Postgres drivers to show in the Access External Data ODBC driver list to pick it
and proceed on to the next blockade.
From: Adrian Klaver [mailto:adrian.klaver <at> gmail.com]
Sent: Saturday, June 09, 2012 4:53 PM
To: Della-Croce, Gregory
Cc: pgsql-odbc <at> postgresql.org
Subject: Re: [ODBC] connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010
On 06/09/2012 01:10 PM, Della-Croce, Gregory wrote:
> *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.
Well ODBCAD32 is for 32 bit drivers which where the ones you installed.
> - 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.
So use those. Or are you saying you do not see the Postgres drivers at all?
> *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? *
Not sure how to answer this. When we left this question last, you had successfully installed the 32 bit drivers.
If you want the 64 bit drivers than go here:
> 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
adrian.klaver <at> gmail.com
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription: