Not able to connect to Oracle DB from the C# code.

Question

Hi,

 

I am developing a WCF service which would typically insert, update and delete data from a Oracle table.

 

The problem that I am facing is:

• My code does not connect to Oracle DB. However, having said that, Sql*Client is installed and connects to oracle DB just fine.
• Also, I had written a OracleTest console application in the D: drive only to test the oracle connectivity. But, to my utter surprise that works just fine.

The connection string seems to be okay to me.

But, whenever I try to debug the WCF service(hosted in IIS 7) I get a "ORA 12557- TNS protocol adapter not loadable" error  when the oracleConnection.open() statement executes.

 

I have absolutely no clue as to what's happening!

 

Eagerly waiting for some help..