I had the same problem. You must run the 32-bit ODBC Admin tool and the 32-bit drivers will show up. Since I was running Windows 7 64-bit, the default ODBC Admin tool only shows the 64-bit drivers. Here's the location of the 32-bit ODBC Admin tool: C:\Windows\SysWOW64\odbcad32.exe
Double-click to run it and then select the "Drivers" tab. You will see the list of drivers.
Just wanted to share my finds and what I had to do.
Basically my issues was not seeing the ODBC Driver on Win 2008 R2 (which is a 64Bit O/S) for Oracle 10g and Oracle 11g while I made sure the Windows ODBC Driver was installed from the Custom Install to make sure they were installed.
On that note:
Confirm the following:
1. Are the entries in the registry?
- Check in *"HKLM\Software\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers\"*
to see if the 'Oracle in ....' is in there, if it is you have installed the ODBC driver so you are good however if you don't see them in there make sure you install the ODBC Driver from the Oracle Installation you ran originally.
2. Make sure you are using the 32-bit ODBC Admin tool as mentioned in the replies here.
- Found in C:\Windows\SysWOW64\odbcad32.exe
Once you launch this and check the Drivers tab, you will probably notice it's EMPTY and that is our problem!
Now the trick here is this:
You HAVE to launch that tool as Administrator in order for the registry information to be written out and displayed in the ODBC Tool. So, run the odbcad32.exe by Right Clicking and picking Run as Administrator_, once this is done you will be set!
This is a one time step to run as administrator, it will register the whole registry list and you should see a whole list of Drivers now under the Driver Tab including the Oracle ODBC drivers.