This content has been marked as final. Show 6 replies
What "Oracle OLE" are you referring to? The Oracle Provider for OleDB (oraoledb)? Or Oracle Objects for OLE (oo4o)?
There is no 64 bit oo4o, and it's not supported to use 32 bit oo4o on a 64 bit OS (although it seems to work).
There is a 64 bit version of OraOledb that installs with the 64 bit client.
Thank you for the reply. I would appreciate if you could elaborate a bit more please.
There is a 64 bit version of OraOledb that installs with the 64 bit client.Which DB Client for Microsoft 64-bit from the following Oracle site should work for database 10.2.0.4 version? Is the higher version of 64-bit Client version works with lower version of Database Server?
There is no 64 bit oo4o, and it's not supported to use 32 bit oo4o on a 64 bit OS (although it seems to work).If there is no 64-bit Oracle Object for OLE, then what is the recommended way or workaround when using with Microsoft Windows Server 2008 R2 64-bit?
Thank you very much.
Edited by: John-M on Jun 4, 2012 2:33 AM
Which are you using then? OO4O or OLEDB?1 person found this helpful
The OLEDB provider doesn't come with instant client downloads you linked.
You can get it via a full client install, or if you can also get it via an ODAC bundle (which comes with instant client).
ODAC is here: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
I'd probably go with ODAC112030_x64.zip which uses the OUI to install, but the XCOPY bundle would work too if you don't mind a bit more of a manual process.
The migration path from OO4O is ODP.NET
Thanks once again.
I'm sorry, I do not know more than this info because it's from our Customer. I'm not responsible for this kind of thing, but will be happy to suggest them as per your suggestion(s) :) Frankly speaking, I personally do not understand these terms much...
## The link you suggested has 64-bit OLEDB 18.104.22.168, will this work with lower DB version of 10.2.0.4. One of my colleage thinks it should work, isn't it?
(ODAC112030_x64.zip) Download includes
64-bit Oracle Provider for OLE DB 22.214.171.124.0
Yes, you can use 11.2 client against a 10.2 database.1 person found this helpful
Thanks a lot.