PostgreSQL ODBC driver not showing up in Control Panel (Data Sources)

Question

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?

Answer 1

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.