17

I installed psqlODBC and when I go to Control Panel -> Data Sources (ODBC) I don't see the Postgres driver installed.

I rebooted, still nothing.

I then noticed that if I launch this control panel applet from the file c:\WINDOWS\system32\odbccp32.cpl the drivers suddenly appear!

This happens on an XP 64 bit machine.

I can't really explain why this is, or what the implications of this are.

When launching from the Control Panel, rundll32's command line is: 

"rundll32.exe" shell32.dll,Control_RunDLL "c:\WINDOWS\system32\odbccp32.cpl",

(this data is from Process Explorer)

When launching from odbccp32.cpl the command line is:

"C:\WINDOWS\system32\rundll32.exe" C:\WINDOWS\system32\shell32.dll,Control_RunDLL "C:\WINDOWS\system32\ODBCCP32.CPL",@0

Any ideas?

Assaf Lavie
  • 73,079
  • 34
  • 148
  • 203
  • I installed this driver the other day and it appeared in the Data Sources straight away, no reboot needed. I didn't do anything out of the ordinary either. – Aaron Chambers Jun 29 '09 at 10:21
  • 1
    Whoever voted to close this question because it belongs on server-fault obviously has no understanding of what ODBC is. Next time, please ignore the tag. – Assaf Lavie Jun 29 '09 at 12:11
  • 1
    +1 I just loved to find this question related to the same problem I have had the whole day with my 32-bits DB2 Data Center Client driver on my Win7 64-bits system. It's a shame I can't upvote more! Thanks for asking this question! =) – Will Marcouiller Jan 28 '11 at 22:48

1 Answers1

31

Did you perhaps install a 32 bit driver? The applet starts the 64-bit version of the odbc admin tool, odbcad32.exe. Try running the 32-bit version in %systemdrive%\Windows\SysWoW64\odbcad32.exe.

Registry redirection makes this a bit of a headache, see http://support.microsoft.com/kb/942976 for more information.

ErikE
  • 857
  • 8
  • 18
  • 6
    Seriously? The 64-bit version is called `odbcad32` and the 32-bit version is in the `SysWoW64` directory? – Nate Aug 07 '09 at 20:11
  • 5
    Yup :-) They're both called odbcad32.exe, WoW64 stands for Windows-on-Windows 64. – ErikE Aug 15 '09 at 11:58
  • +1 I would have liked to upvote this answer 10 times at least! I took the whole day turning around this problem with my freshly installed DB2 data center client drivers. The drivers are 32-bits, and my system is 64-bits. I just so happy to have found this answer, really! You saved my life! ;-) Thanks! – Will Marcouiller Jan 28 '11 at 22:47
  • why would anyone be surprised? this is coming from the company who got the world used to pressing the "start" button to "stop". – Jeff Maass Apr 17 '13 at 14:57
  • So if you are in Windows 7 64 bits open a command windows and run %windir%\SysWOW64\odbcad32.exe – Mauricio Gracia Gutierrez Jun 10 '14 at 15:48