Oracle EBS LOB Adapter

Very not so successful, working with oracle. I installed the BizTalk LOB adapter for Oracle EBS (E-Business Suite) and encountered the following problem:

COULD NOT LOAD FILE OR ASSEMBLY ‘ORACLE.DATAACCESS, VERSION=2.111.7.20, CULTURE=NEUTRAL, PUBLICKEYTOKEN=89B483F429C47342′ OR ONE OF ITS DEPENDENCIES. THE SYSTEM CANNOT FIND THE FILE SPECIFIED.

I took some time before I found the right installation. Oracle 11g client comes standard with 2.111.6 and that's exactly the problem. There's a patch available that only contains jar files and such. I just need a SETUP.EXE please! Don't want to copy and compile through some console windows :/ Or you have to login and have an Oracle customer ID or so.

Well, after some searching i installed the following and it worked:


Oracle 11g ODAC 11.1.0.7.20 with Oracle Developer Tools for Visual Studio
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html


Hopefully it helps other people searching for a solution. Ow yes! And restart your instance and Visual Studio afterwards might help :)