Fw: BUG #5640: ODBC driver installed but not found

Thanks Craig for your answer, and sorry for a late response. I did try the
c:\windows\system32\odbcad32 program, and pressed Add... but it does not
show any postgreSQL drivers. The driver I got installed by running
Application Stack Builder 2.1.0 is psqlODBC v09.04.0200-1, and it was
installed in both c:\Program Files\psqlODBC\0804\bin and in c:\Program
Files
(x86)\psqlODBC\0804\bin.

I then looked at the registry and found that in
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI there were only these two
SQLServer entries but no postgreSQL entries (like there is in my Vista PC,
where the ODBC works fine). I edited the keys and values there, as copies
from the Vista PC, but that did not help. - Finally I found the PostgreSQL
entries in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI, but
obviously odbcad32.exe cannot find them no matter where these keys are.

Anyway, the database works well via pgAdmin III, but the ODBC does not. I
cannot setup a data source with odbcad32. I hope this info above helps you
understand what might be wrong. Has anyone got the ODBC working in a
Windows 7 Pro 64 bit?

Hannu

----- Original Message -----
From: "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>
To: "Hannu Pohjanpalo" <hannu(dot)pohjanpalo(at)winware(dot)fi>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Friday, September 03, 2010 6:20 AM
Subject: Re: [BUGS] BUG #5640: ODBC driver installed but not found

> On 3/09/2010 2:36 AM, Hannu Pohjanpalo wrote:
>
>> I installed PostgreSQL 8.4.4 in my Windows 7 Professional (64 bit), and
>> ran
>> (as Administrator)Application Stack Builder to download and install the
>> ODBC
>> driver. This installation looked perfectly successful, but when starting
>> Control Panel / Administrative Tasks / ODBC Settings, and press Add..., I
>> cannot find this PostgreSQL ODBC driver, I can only see two SQLServer
>> drivers. I uninstalled and tried again: same result. Have you seen this
>> before? All ideas are welcome, thanks!
>
> You have to run the 32-bit ODBC administrator. PostgreSQL doesn't install
> a 64-bit ODBC driver yet, and anyway you'd need to configure the 32-bit
> one for access by any 32-bit apps.
>
> --
> Craig Ringer
>
> Tech-related writing at http://soapyfrogs.blogspot.com/
>
>