Hi all,

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;"; 
 /* 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                  */
            conn.Close();
            conn.Dispose();

I am getting  the following exception:
"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.