How to retrieve data from Oracle db in c#

Total Post:154


 1419  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                  */
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.


Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.