Oracle client is verified to be able to connect to the DB.
However, whenever I try to load up the web application, on the first load, it will always take a while to connect, and it will show me the error:
The 'OraOLEDB.Oracle.1' provider is not registered on the local machine
But when I reload, the web application will load like normal.
I'm on IIS7.5, and it was working on IIS6.0.
My Web app is on 32-bit ODAC, and i have 64-bit ODAC installed. I also tried to use 32-bit ODAC and it shows me:
ORA-12154: TNS:could not resolve the connect identifier specified
But on refreshing the page, it connects to the Web Apps like normal as well...