hi,
I have developed a MVVM application using Visual Studio 2010, Entity Framework and Oracle Data Access v. 4.112.3.0. Development computer uses a Oracle Client 10.2.0 and TNSNAMES.ORA to connect to Database. Then I deployed my app to a web server, to share it with the users
Everything is Ok, until I try to run the deployed app from a "clean" user computer (i.e. no Oracle Client and tnsnames.ora installed). Of course, app is unable to reach database!
I read a lot of articles suggesting to use Oracle Instant Client 11.1.0.6 and Odac11 Xcopy, and copy some DLL's into project root. I also tried to replace Oracle Data Access with Oracle Data Provider for .Net Managed Driver, release 12.1.0.1 (for 64-bit development computer). Really, I got to make my app work using a "local" tnsnames.ora (put in the project folder), and then bypassing my oracle client. but every attempt of running the deployed app was unsuccessful. App keeps looking for a tnsnames.ora in the client computer.
How can I fix this issue? I guess I should be able to package some oracle driver, and maybe a minimal tnsname.ora into my deployment, but I dont know how to do it. Please help
thanks