I am new to Oracle database accessing from C#.
I am trying to access the database of a oracle database named "orcl" from C#.
There is a problem in connection open. The following is the code I have written under a click button:--
string oradb = "Data Source=orcl ; User Id=sysman ;Password=abc123;";I am getting the following exception:
/* CODE */
//string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521))"
// + "(CONNECT_DATA=(SERVICE_NAME=ORCL)));" + "User Id=hr; Password=hr;"OracleConnection conn = new OracleConnection(oradb);
conn.Open(); //Open the Connection
/* other statements */
"An unhandled exception of type 'Oracle.DataAccess.Client.OracleException' occurred in Oracle.DataAccess.dll
Additional information: External component has thrown an exception." Please help me to solve the problem.....
Thank you all in advance.