通过

WCF-Oracle Adapter for BizTalk 2009

  • 项目

to be able to develop BizTalk applications to work with Oracle 11g here are the configurations:

Development Machine (Visual Studio) BizTalk 2009 Machine
Oracle Data Access Components 2.111.7.20 ODAC.NET Oracle Client (this installs the Oracle Data Provider Oracle.DataAccess.dll 2.7.111.0 in the GAC)
  Oracle Data Access Components ODAC.NET
Consume Adapter Metadata Visual Studio Add in (this comes inside WCF LOB SDK) WCF SDK LOB
WCF LOB SDK (the online package is corrupted, you will find a lot of blogs online talking about command line install, but it is not enough, because if you use the command line install , it wont install the full package, it will only install WCF SDK, but you actually need to install the VS add in for the Adapter from the package) anyway , how to do that ?

regsvr32 c:\windows\system32\msi.dll

regsvr32 c:\windows\system32\msisip.dll

regsvr32 c:\windows\system32\msihnd.dll

%Windir%\system32\msiexec /unregserver

%Windir%\system32\msiexec /unreg

%Windir%\system32\msiexec /regserver

regedit /s "Installer2Manual.reg"

RMDIR /S /Q %TEMP%

MD %TEMP%

del /q %systemdrive%\temp\*.*

del /q %systemdrive%\%windir%\temp\*.*

 BizTalk Adapter Pack 2.0
BizTalk Adapter Pack 2.0  

 

as you can see, the confusion comes from the need for both versions (2.111.7.0  comes with Oracle Client ) and (2.111.7.20 comes with ODAC.NET ) if we only have 1 machine. so we need to install both packages : Oracle Client 11g and ODAC.NET for client