Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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