Menu
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?
769
Open the ODBC Data Source Administrator. Select the System DSN and click Add. The Create New Data Source dialog will appear. Choose Devart ODBC Driver for PostgreSQL and click Finish.
The PostgreSQL ODBC Driver is a powerful tool that allows you to connect with live PostgreSQL data, directly from any applications that support ODBC connectivity. Access PostgreSQL databases from virtually anywhere through a standard ODBC Driver interface.
ODBC driver for PostgreSQL doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows and Linux, both 32-bit and 64-bit.
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.
132
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
