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/
>
>
