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

postgresql odbc dsn
Jeff G picture Jeff G · Mar 2, 2012 · Viewed 12.2k times · Source

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.

Answer

bohica picture bohica · Mar 4, 2012

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.

Related questions

Setting up PostgreSQL ODBC on Windows

I have the latest 64 bit version of PostgreSQL. I am running Win 7 64 bit. I had installed the ODBC driver (via the initial installer) when I installed PG, and upgraded it to the latest version from http://www.postgresql.org/ftp/…

Read More
How do I change a Crystal Report's ODBC database connection at runtime?

I have a report made with Crystal Reports 2008 that I need to deploy a production system which means that I need to be able to change the database connection at runtime. The database is PostgreSQL 8.3.0 and the connection I use …

Read More
Connecting Excel to PostgreSQL via VBA

Is it possible to make query like SELECT from VBA in Excel, so I can query a PostgreSQL DB from Excel? If is possible please explain me how to connect to the database. I was looking in Google but found …

Read More