This content has been marked as final. Show 2 replies
The 10g (there is no such thing as 10i) client can talk to an 11 server, so that's going to be the one you want since Biztalk also supports it. You're probably going to have to ask on a Biztalk forum for help setting that up if it's anything beyond "create an ODBC connection".
The Biztalk Adapter interface with Oracle software has information, requirements per referenced document that does not make sense.
E.g. "10i" does not exist and the requirement "Oracle ODBC driver 126.96.36.199.4" means that only 9.2 Client can be used. (Mixing parts from one Database Client product version with another version is not allowed/supported/certified.)
Btw, does that machine happen to have Itanium hardware? (probably no, since you stated x64)
For Oracle's OS requirements, 2003 was certified with/from 188.8.131.52 (and likely also terminal patch set version 184.108.40.206). Not sure about Server 2003 R2, 32 or 64-bit. I'm pretty sure 10.2 was certified on 2003 R2, but the note likely refers to 10.1 versions (before it was known it would be labeled 10g, g for grid replacing the i ).
This FAQ may have some more information: http://www.oracle.com/technetwork/database/windows/faq-100614.html
For Oracle client - server interoperability and certification, there's a support matrix on MOS. See doc id 207303.1.
It seems 9.2 is supported on the wire to operate with 11.2 server, but Client with at least patch set 220.127.116.11 is required.
So, I guess best bet is to find updated requirements.
If you manage to get hold of 18.104.22.168, after verifying that 2003 R2 is ok, then it looks like the puzzle could be put together for a complete picture.
For ease of install, take a look at the Instant Client. (However, there's no 9.2 IC, that type of client install came later)
some corrections, specially about 9.2 version
Edited by: orafad on Dec 19, 2012 10:58 PM