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" <cr...@postnewspapers.com.au>
To: "Hannu Pohjanpalo" <hannu.pohjanp...@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/
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
