I have developed a .Net C# based website, which is dependent mostly on Oracle database. To access the DB I have been using Oracle ODAC 11G. (Oracle.DataAccess.dll version: 1.111.6.10).
The website works just fine when I run it locally for testing (Ctrl + F5 on VS 2013). However, after publishing it locally (my PC runs IIS) I encountered a wired error: "The provider is not compatible with the version of oracle".
I have already made sure the app set to run in 32 bit mode in the iis console. But I still can't figure out why the website works when I run it from visual studio, and doesn't work when I publish it.