Skip site navigation (1) Skip section navigation (2)

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

From: "Della-Croce, Gregory" <Greg_Della-Croce(at)wycliffe(dot)org>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010
Date: 2012-06-10 02:16:39
Message-ID: F1CFB1E7A51CD846898BB039F441E04F095A53C691@elijah (view raw or flat)
Thread:
Lists: pgsql-odbc
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.   

Greg Della-Croce
-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)gmail(dot)com] 
Sent: Saturday, June 09, 2012 4:53 PM
To: Della-Croce, Gregory
Cc: pgsql-odbc(at)postgresql(dot)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:
http://www.postgresql.org/ftp/odbc/versions/msi/

and get

psqlodbc_09_01_0100-x64.zip
>
> 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
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

pgsql-odbc by date

Next:From: Adrian KlaverDate: 2012-06-10 17:51:21
Subject: Re: connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010
Previous:From: Adrian KlaverDate: 2012-06-09 20:53:04
Subject: Re: connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group