As mentioned, it does work if you install the 32 bit ODAC, but I found the most recent installer doesn't register OO4O properly. So if you go here: http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html
Download the Universal Installer version of 22.214.171.124.1 (third download on the page), you should find that you can make OO4O work in 32 bit apps again. For now, at least. Sooner or later you're going to need to migrate away from it.
I currently have a VB6 application using OO4O (oip10.tlb/dll). Our company is moving to x64 Windows 7. My application is not compatible with the version of Oracle (10.2) being installed on the Windows 7 boxes.
What are potential workarounds for this situation?
I find it rather frustrating that I build an application to use Oracle functionality that is later (now) being dropped... but it is what it is.
If I'm to move to something other than OO4O, what is the best choice?
Assuming it's a different VB6 project reference and the connection object can be used the same way programmatically, it shouldn't be too hard... but if I have to reword all my queries and Oracle procedure calls... it's going to be ugly.