GiriPrasad G

GiriPrasad G

  • NA
  • 8
  • 9.3k

Connect Oracle from C# Web Application

Oct 5 2012 7:36 AM
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.


Answers (4)