Thread: 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.klaver@gmail.com

Thanks for being someone who answered.   I am saying that I do not see the ODBC drivers for PostgreSQL at all.   I only
seethe 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
itas 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
proceedon to the next blockade.    

Greg Della-Croce
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@gmail.com]
Sent: Saturday, June 09, 2012 4:53 PM
To: Della-Croce, Gregory
Cc: pgsql-odbc@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:
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.klaver@gmail.com

On 06/09/2012 07:16 PM, Della-Croce, Gregory wrote:
> Thanks for being someone who answered.   I am saying that I do not see the ODBC drivers for PostgreSQL at all.   I
onlysee 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.

Have you looked at this KB article:
http://support.microsoft.com/kb/942976

Though I would have to say the above confuses as much as it enlightens.

At this point it would seem easiest to start from the beginning. I for
one am totally confused on where we are at:)

1) From Control Panel uninstall psqlodbc

2) Reinstall the 64 bit version using the msi in psqlodbc_09_01_0100-x64.zip

3) As the user that will be using Access open the the ODBC manager(the
64 bit one) in Control Panel to set up the user DSN.

4) Open Access and select the DSN.


Should you decide not to try all of the above try starting at 3.

>
> So the problem is getting the Postgres drivers to show in the Access External Data ODBC driver list to pick it and
proceedon to the next blockade. 


>
> Greg Della-Croce



--
Adrian Klaver
adrian.klaver@gmail.com