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@postnewspapers.com.au>
 To: "Hannu Pohjanpalo" <hannu.pohjanpalo@winware.fi>
 Cc: <pgsql-bugs@postgresql.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/
>
>