I made c# asp.net web applciation with oracle 10g database using visual studio 2008. It works fine with local environment. After I published on my web server and received the following error:
*Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.100, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. *
I put Oracle.DataAccess.dll directly into my application bin and add reference from bin and publish the apps. I received the following error:
*Unable to load DLL 'OraOps10.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) *
I put OraOps10.dill into my application bin and tried to add reference but visual studio didn't allow to add it.
A reference to OraOps10.dll could not be added. Please make sure that the file is accessible, and that it is a valid assembly or COM component.
I researched a lot about this issue and get confused.
Do I have to install whole oracle client into my web server in order to run my application on the web?
p.s. I am using free asp.net web hosting service and I cannot install oracle client on the server.
I would appreciate if anyone can help me.