Oracle.DataAccess redirect for WCF Oracle adapter RRS feed

  • Question

  • I'm using the WCF Oracle adapter to connect to Oracle in Biztalk 2010. By default, the Oracle adapter in Adapter Pack 2 and 3 uses the Oracle.DataAccess dll, version Is it possible to tell the adapter to use the Oracle 10 client (Oracle.DataAccess, version Some functionality in my Biztalk solution is accessing an Oracle 8i database. Since Oracle 8i is not supported by the 11 client, I need the adapter to use an earlier version of the Oracle.DataAccess assembly. But at the same time, I need the support for composite operations which is not available in Adapter Pack 1.0.

    What I tried so far is including an assemblyBinding section in the machine.configs (in 2.0 Framework, 2.0 Framework64, 4.0 Framework, 4.0 Framework64). Also, I added the same section to Microsoft.Adapters.OracleDB.config in C:\Program Files\Microsoft BizTalk Adapter Pack(x64)\bin.

    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
       <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" culture="neutral" />
       <bindingRedirect oldVersion="" newVersion=""/>

    This doesn't seem to work. After I restart my host instances, the adapter still tries to load the version of the Oracle.DataAccess assembly. How can I tell the adapter to load the Oracle 10 client dll?



    Tuesday, November 1, 2011 12:31 PM


  • i vaugely remember this i had done in my past.

    1) Browse to the Oracle.DataAccess.dll from GAC using windows explorer.  "C:\Windows\Assembly\GAC_MSIL\"

    2) Open the folder "Oracle.DataAccess".

    3) Open the corresponding version folder.

    4) Update the config file "newVersion" section to point to the old version.



    Tuesday, November 1, 2011 12:40 PM