Your answer did the trick.
Here is a little more information for others who are using 64 bit windows 7 computers but have 32 bit Microsoft Office 2010:
1. select Postgresql ODBC drivers through the Postgres stackbuilder or download from:
the 32 bit driver I used is: psqlodbc_09_01_0100.zip.
2. once the driver downloads click on the zip file to open it and run the .msi file.
3. install the driver with all the default settings.
Trap: If you now try to create a new data source (DSN) using the regular procedure: Control Panel-Administrative tools-Data sources, you will not see the 32 bit Postgres driver listed driver listed so you can't create a new data source with it.
Solution: If you run the file Jason identified:
Then the same data source creation dialog pops up, but now the 32 bid postgres driver is listed and you can create your data source as you like.
From: Jason Pickering [mailto:email@example.com]
Sent: Wednesday, August 08, 2012 4:10 PM
Subject: Re: [Dhis2-users] psqlodbc driver on 64 bit windows 7 computer
To setup DSN for 32-bit application you must use:
and for 64-bit application you must use:
I suspect your office is 32 bit.
On Wed, Aug 8, 2012 at 4:03 PM, Wilson,Randy <firstname.lastname@example.org> wrote:
I've just set up a new laptop and have not been able to find the
correct psqlodbc driver to use with DHIS-2 running Postgres 8.4.
The only drivers that install and show up in the ODBC drivers when I
create a new data source are the x64 drivers. The other drivers seem
to install correctly but do not appear in the list. When I use the 64
bit driver I can't connect with Microsoft Excel or Access 2010 - they
give a message saying that the architecture is different.
Has anyone found a driver that will work?
Mailing list: https://launchpad.net/~dhis2-users
Post to : email@example.com
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp