How to retrieve data from Oracle db in c#

Total Post:154

Points:1086
C#
 1130  View(s)
Ratings:
Rate this:
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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!