Обсуждение: 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/ > >
On 8/09/2010 12:53 AM, Hannu Pohjanpalo wrote: > I did try the > c:\windows\system32\odbcad32 program, and pressed Add... but it does > not show any postgreSQL drivers. That's the 64-bit version of the ODBC administrator. Yes, that's confusing. The name is a holdover from the 16-bit to 32-bit Windows transition, when "odbcadm" was the 16-bit version and a new 32-bit versoin "odbcad32" was provided. Apparently many apps and installers depend on odbcad32.exe having that name and path, so Microsoft landed up being stuck with it despite the stupid name. It's the same reason the "system32" directory is still called that on 64-bit Windows. See: http://support.microsoft.com/kb/942976 You'll see in that article that the 32-bit ODBC administrator is: %systemdrive%\Windows\SysWoW64\odbcad32.exe (which you can launch from "Start->Run" using the path above). You need to use the 32-bit ODBC administrator to set up data sources for 32-bit applications using 32-bit drivers. That MSDN article also appears to say that you *cannot* use a 32-bit ODBC driver in a 64-bit application. That means that you'll still only be able to use the PostgreSQL ODBC driver with 32-bit applications until a 64-bit ODBC driver is released. Apparently there's now 64-bit support in the psqlODBC sources: http://www.mail-archive.com/pgsql-announce@postgresql.org/msg01822.html Perhaps this needs to go in the psqlODBC FAQ? http://psqlodbc.projects.postgresql.org/faq.html Anyway: what app(s) do you want to use PostgreSQL with over ODBC? Are they 32-bit or 64-bit builds? > 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). Your vista machine - is it a 32 bit or 64 bit version of Vista? I'm guessing 32-bit. > 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. AFAIK that's the right place for the registry entries. They're 32 bit drivers, so they can't be used directly by 64-bit code, they have to run via the wow64 layer. > Anyway, the database works well via pgAdmin III, but the ODBC does not. That's because pgAdmin III uses libpq directly, it doesn't use ODBC. That's also why you don't have to mess around configuring data sources. > Has anyone got the ODBC working in a Windows 7 Pro 64 bit? I don't use 64-bit Windows. I haven't seen many reports either way here, but perhaps there's more discussion of it on the EnterpriseDB web forums: http://forums.enterprisedb.com -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/