BizTalk oracle error when configure bindings

424 views Asked by At

I configured BizTalk 2020 Server with CU1 and I installed Oracle Client in this way.

  • Download ODAC183_x64 & ODAC183Xcopy_32bit.
  • I install odac183 with setup and then I'm going to put in gac oracle.dataaccess ( Version=4.122.18.3) in x64 and x86 version.
  • I imported and old binding and oracle connection seems ok.

But, when I'm going to change configuration, I receive this errorInvalid binding. (Microsoft.BizTalk.Adapter.Wcf.Common).  The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. (Oracle.DataAccess). An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007008) (Oracle.DatacAccess) Any suggestion?

1

There are 1 answers

1
Emilio Marino On BEST ANSWER

Problem was that I installed Oracle.DataAcces(x64-x86) through gacutil. You should install dll with: oraprovcfg.exe /action:gac /providerpath:Oracle.DataAccess.dll that supplies to put dll in gac and change machine.config.

From version 18c , Oracle Client don't install automatically dll in gac and don't update

machine.config