Connect Oracle from C# Web Application

GiriPrasad G

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

GiriPrasad G14y ago
ORA-06413: Connection not open.

above 2 solutions are not solved my problem
GiriPrasad G14y ago
Which Name space need to mention for OracleConnection ,i mean there is no namespace is not listing please check the attached image
R ACHUTHA14y ago
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 Vaishya14y ago

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();
            }