How do I remove USER DSN when they don't exist in my registry

2
votes

So my computer was recently rebuilt and all my settings were re-imaged to a new computer. This meant that most drivers were not re-installed. Right now I have a bunch of USER DSN that are invalid. I cannot remove or configure them. I get the following error when I try either: http://imgur.com/a/drBkI

Google tells me to go to regedit but nothing exists in the following folder HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC Data Sources.

I tried just re-installing the the Posgres ODBC driver but no go. Ran data sources administrator GUI as an administrator and windows still won't let me remove them.

1
postgresqlodbcdsn

1 Answers

7
votes

Not all data sources are in that key, especially if you have a 64 bit machine. 64-bit ODBC explains where you can find 32/64 bit data sources in the registry.

 HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI
 HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI

It also explains about registry redirection. The key you are looking is for system DSNs even on a 32 bit machine so you want to look in HKEY_CURRENT_USER.