Home > DeveloperSection > Forums > How to retrieve data from Oracle db in c#
Manoj Bhatt
Manoj Bhatt

Total Post:153

Points:1079
Posted on    January-07-2016 10:35 PM

 C# C#  Database  Database Connection 
Ratings:


 0 Reply(s)
 266  View(s)
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
.


Don't want to miss updates? Please click the below button!

Follow MindStick