I have a custom application in Excel (an Excel add-in) which uses oo4o. I just tried to load it on a windows 7 with Oracle 11gR2 64-bit but I found (from some searching) that oo4o is not supported in Oracle 11gR2 64-bit (which is the only supported Oracle client for Windows 7).
So, if I can't use oo4o, what should I be using? The Excel add-in vb code calls stored procedures, issues commits and rollbacks, keeps a session open for multiple transactions, etc. I want to keep the code in the Excel VB add-in, so is there another Oracle option?
Oracle 11gR2 64-bit isn't the only supported Oracle client for Windows 7. 32 bit 10205 and 32 bit 11.2 are supported as well.
However, 32 bit OO4O is not supported on x64 in general. That's not to say that it doesn't work though ~ it's just not supported.
Your options would be:
1) install 10205 or 11202 32 bit client with oo4o, and use it even though it's not supported.
2) rewrite the app to use ADO and Oracle's OLEDB provider instead if you need to stick with vb
3) the recommended oo4o migration path in general is ODP.NET
Probably not what you wanted to hear, but hope it helps,