Unable to connect to oracle DB from Biztalk send port from Biztalk 2020 prod server

AboorvaRaja Ramar 41 Reputation points
2024-01-23T09:54:34.4133333+00:00

I have installed Biztalk 2020 and installed the 64 bit. All the installation is done and working. Last i want to send message to Oracle DB, i am using the biztalk send port to send this message. When sending the messge i am getting below error: "

System.BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342'. This assembly was compiled for a different processor.
   at Microsoft.Adapters.OracleDB.OracleDBBinding.Initialize()
   at Microsoft.Adapters.OracleDB.OracleDBBinding.CreateBindingElements()
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.InitializeValues(IBaseMessage message)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2..ctor(IBaseMessage message, WcfTransmitter`2 transmitter)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfTransmitter`2.GetClientFromCache(String spid, IBaseMessage message)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfAsyncBatch`2.BatchWorker(List`1 messages)


I have installed Oracle ODAC 12/18.3 version to make sure i have the latest dll. User's image

In machine config i have configured with the latest dll. But still i am getting an errorUser's image

When i am creating the Oracle sendport i am getting this error, i am not sure where to update the config to support 19.1 version. User's image

Please advice , we need to move to prod this weekend.

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
349 questions
{count} votes