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