15

On my Windows 7 machine, I created an ODBC data source to an Oracle database via the ODBC Data Source Administrator (c:\windows\SysWOW64\odbcad32.exe). Sometime later, I had to uninstall and reinstall Oracle Client, which resulted in a different Oracle home. So the existing ODBC data sources no longer worked. However, if I try to remove the data source, I get the following error messages:

---------------------------
Microsoft ODBC Administrator
---------------------------
The setup routines for the Oracle in ORA112_HOME ODBC driver could not be found.  Please   reinstall the driver.
---------------------------
OK   
---------------------------

Then 

---------------------------
Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed
---------------------------
Errors Found:

Component not found in the registry
---------------------------
OK   
---------------------------

How do I remove these ODBC data source entries?

Improve this question

2 Answers 2

Reset to default
23

They are defined in the registry under \ODBC\ODBC.INI\ in various places depending on if the definition is

System User:

HKEY_CURRENT_USER\Software\ODBC\ODBC.INI

32-bit:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI

64-bit:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

To delete a data source, you have to delete the data source key under ODBC.INI and the entry under ODBC.INI\ODBC Data Sources linking your data source to the driver.

Improve this answer
5

I had same issue here. But I found my 32 bit entries under:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI
Improve this answer
2
  • 2
    This was already stated in an answer submitted over 2 years ago.
    – Ramhound
    Commented Apr 5, 2016 at 15:31
  • 3
    He has specified ODBCINST.INI was his solution, the original answer specifies ODBC.INI.
    – Dave Lucre
    Commented Mar 23, 2017 at 5:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .