1
Answer

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

Jonantik Chowdhury

Jonantik Chowdhury
10y
1.2k
1
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..
Answers (1)
Next Recommended Forum