Connect Oracle from C# Web Application

Question

ORA-06413: Connection not open.

try
            {
                OleDbConnection con = new OleDbConnection("provider=MSDAORA;data source=XXXXX;user id=XXXXX;password=XXXX;server=XXXXXX");
                con.Open();
            }
            catch (Exception Ex)
            {
                Response.Write(Ex.ToString());
            }

Above code is working fine(Connecting DB) in windows applications
but not working in Web Applications on same system.

system configurations are

Client : Win 7 Professional 64 bit laptop
DB Client : 10g 32 bit

DB Server : 10g 32 bit

Please help me out i used same code in lot of applications ,if i change the above procedure i need to change in all apps,so please give me a better solution
Thanking you.

GiriPrasad G · Answer

ORA-06413: Connection not open. above 2 solutions are not solved my problem

GiriPrasad G · Answer

Which Name space need to mention for OracleConnection i mean there is no namespace is not listing please check the attached image

R ACHUTHA · Answer

hi which error message your getting while working with web application can you share it and mean while refer the below link http://www.startvbdotnet.com/ado/oracle.aspx

Kunal Vaishya · Answer

Use like this //-------------------------------------------------------------------------------------- string oradb = Data Source=XE;User Id=hr;Password=hr; ; OracleConnection conn = new OracleConnection ( oradb ); // C# try { conn . Open (); string sql = SELECT FIRST_NAME FROM EMPLOYEES WHERE EMAIL='SKING' ; // C# OracleCommand cmd = new OracleCommand ( sql  conn ); cmd . CommandType = CommandType . Text ; OracleDataReader dr = cmd . ExecuteReader (); // C# dr . Read (); //label1.Text = dr[dname].ToString(); // C# retrieve by column name label1 . Text = dr . GetString ( 0 ). ToString (); // return a .NET data type //label1.Text = dr.GetOracleString(0).ToString(); // return an Oracle data type } catch ( OracleException ex ) { label1 . Text = ex . Message ; } finally { conn . Close (); }