BizTalk2020 WCF-OracleDB adapter issue

Naresh Devalla 1

BizTalk 2020 WCF-Oracle DB adapter error, Installed Oracle 18.2 64bit ODAP and Gac'd the dll using OraProvCfg /action:gac /providerpath:Oracle.DataAccess.dll. Updated the Machine Config to point to the new version. Still getting same error.

I have tried with 19.1 and 12.2 clients , I also got the same error. Is there any documentation on the procedure to install oracle client and ODP.net on BizTalk Server 2020?

Colin Dijkgraaf 1,346 Reputation points

2021-07-22T21:05:31.747+00:00

Did you install both the 32 and 64 bit versions? The BizTalk Admin console requires the 32 bit. Did you do an assembly redirect in the both 64 and 32 bit machine.config files?
Naresh Devalla 1 Reputation point

2021-07-23T20:13:26.203+00:00

II have installed only 64, But I have assembly redirect in the Machine config file too, Let me try installing 32bit too.
Naresh Devalla 1 Reputation point

2021-07-26T20:00:50.403+00:00

I have also installed 32 bit client using ODP.NETUnmanaged19.10Xcopy32bit. No luck , I am running out of ideas here.
Colin Dijkgraaf 1,346 Reputation points

2021-07-26T20:48:02.637+00:00

Did you also do the assembly redirect in the 32 bit machine.config?
Naresh Devalla 1 Reputation point

2021-07-27T13:08:38.003+00:00

Yes both places
Kamlesh Kumar 3,861 Reputation points

2021-08-20T10:06:41.903+00:00

Hi There,

Thank you for asking this question on the Microsoft Q&A Platform.

Please check the below Microsoft Doc link,

https://video2.skills-academy.com/en-us/biztalk/adapters-and-accelerators/lob-and-enterprise-2020-support

Regards,
Kamlesh Kumar

If this answer solved your problem, please click the Verify Answer button (found below the answer) to help other users who have the same question.

Share via

BizTalk2020 WCF-OracleDB adapter issue

Your answer