Thanks Jason!
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:
http://www.postgresql.org/ftp/odbc/versions/msi/
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:
%WINDIR%\SysWOW64\odbcad32.exe
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.
Randy Wilson
···
-----Original Message-----
From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: Wednesday, August 08, 2012 4:10 PM
To: Wilson,Randy
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] psqlodbc driver on 64 bit windows 7 computer
Hi Randy,
To setup DSN for 32-bit application you must use:
%WINDIR%\SysWOW64\odbcad32.exe
and for 64-bit application you must use:
%WINDIR%\System32\odbcad32.exe
I suspect your office is 32 bit.
Best regards,
Jason
On Wed, Aug 8, 2012 at 4:03 PM, Wilson,Randy <rwilson@msh.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?
Randy Wilson
HMIS Advisor
MOH Rwanda
_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help