Problem:
When invoke a service method via WCF Test Client, you get an error message like this:
Assembly Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342 was not found. Reinstall the assembly or Visual Studio. The application cannot continue and will exit.
Screen shot:
After you click “OK”, the program will exit.
Causes:
It seems that it’s caused by BizTalk.
Solution:
When you run the WCF Test Client, modify the machine.config file (located in C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config)
by commenting out all the nodes who contain the word “Oracle”.
<!--<section name="system.data.oracleclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>--> <!--<add name="oracleEBSAdapterInboundTransactionBehavior" type="Microsoft.Adapters.OracleEBS.OracleEBSInboundTransactionBehavior, Microsoft.Adapters.OracleEBS, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>--> <!--<add name="oracleDBAdapterInboundTransactionBehavior" type="Microsoft.Adapters.OracleDB.OracleDBInboundTransactionBehavior, Microsoft.Adapters.OracleDB, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>--> <!--<add name="oracleEBSAdapter" type="Microsoft.Adapters.OracleEBS.OracleEBSBindingElementExtensionElement, Microsoft.Adapters.OracleEBS, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>--> <!--<add name="oracleDBAdapter" type="Microsoft.Adapters.OracleDB.OracleDBAdapterExtensionElement, Microsoft.Adapters.OracleDB, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>--> <!--<add name="oracleEBSBinding" type="Microsoft.Adapters.OracleEBS.OracleEBSBindingCollectionElement, Microsoft.Adapters.OracleEBS, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>--> <!--<add name="oracleDBBinding" type="Microsoft.Adapters.OracleDB.OracleDBAdapterBindingSection, Microsoft.Adapters.OracleDB, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>-->
Now you can use your WCF Test Client normally.