Could not connect oracle when WCF service is hosted in IIS RRS feed

  • Question

  • User1281245994 posted

    My WCF programs runs fine from visual studio environment and can fetch data successfully from Oracle database. But when I published the service and hosted that in the IIS of the same machine (development pc with 32 bit win7 and IIS 7.5), I am getting an error of null reference. I removed the oracle part form the service and sent some hard coded value for testing, then it was running perfectly. I have used ODP.Net for 32 bit and oracleClient to access the database. Machine.config in C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config file already caontains entries for oracle.dataaccess.client and oracle.managedDataAccess.client.

    Am I missing any DLL? Or is there nay permission that is to be given to IIS? Please help.

    Thursday, January 9, 2014 7:24 AM