Connect to Oracle Database Version using Oracle.DataAccess.dll

[Anonymous]

Hi,  I am connecting to remote Oracle database version - 11.2.0.3.0 through my code on VS2017 by adding reference of "Oracle.DataAccess.dll" (Version=2.112.2.0) file successfully. When I'm trying to connecting through blue prism code stage, I'm getting below exception: "Could not execute code stage because exception thrown by code stage: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified." Machine Details:  I've got Oracle Client 64 bit installed on my machine. I have added references of DLL by keeping them in separate folders like: "C:\ProgramData\Blue Prism Limited\Oracle.DataAccess.dll" Can some one please guide me what is going wrong with this code? Are there any other references to be added that I'm missing here.

[John__Carter]

Could it be that Oracle.DataAccess.dll is trying to make references to somewhere else too?

[Anonymous]

Thanks for your response John !! I'm not getting how this DLL could make references somewhere if we kept it at entirely separate location -""C:\ProgramData\Blue Prism Limited\Oracle.DataAccess.dll"". Could you please help me understanding this?

[RajeshKizhakkev]

Hi Tushar , Did you egt a resolution for this ? I am facing same issue Appreciate your response