CODEWITHSUNDEEP
postgresqlodbcdsn
Jeff G
Jeff G

Reputation: 33

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

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: https://i.sstatic.net/IGJi0.jpg

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.

Upvotes: 3

Views: 13427

Answers (1)

bohica
bohica

Reputation: 5990

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.

Upvotes: 8

Related Questions