Been having a series of Oracle Home problems as those helpfully answering my questions would know!
Here's the immediate problem (I'll provide more details on what led to this whole circus if you think it would be useful)
I've got Oracle 10g, 11g clients installed. Previously I also had a 9.2 client on which I had removed.
Due to a some problems I had to install an Oracle 9 OLE DB patch (which also installs the 9 client) - package as avaialble in the ready installs in the bank.
The first thing that I noticed in the Universal installer was that under installed products now it only showed Oracle Home 9 - it couldn't find 10 and 11 (which previously were visible)
Now, my VBA application was still not able to connect to the database (through OraOLEDB provider). I changed the ORACLE_HOME env variable to point to 9 instead of 11 but still no luck connecting.
Removed the OLEDB patch 9 (which also uninstalls the 9 client). Now the OUI cannot find any oracle products installed although 10 and 11 are very much installed!!
Any ideas why this is happening and how to set it right please?