CatastrophicFailure Error
Hi ,
When I am Executing C# webapplication ,
I am getting Error Like Below
Database Error --> Catastrophic failure
stack Trace: at
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) at System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) at System.Data.OleDb.OleDbConnection.Open() at Purchaseorder.frmLogin.btnSignIn_Click(Object sender, EventArgs e) in
c:\inetpub\wwwroot\pott\login.aspx.cs:line 63
In login page when User Clicks on SignIn Button The Click Event Code is as follows:
Code:
OleDbConnection con=new OleDbConnection("provider=msdaora.1;user id=something;password=something;Data source=something ");
private void btnSignIn_Click(object sender, System.EventArgs e)
{
try
{
Str=//something
OleDbCommand cmd=new OleDbCommand(str,con);
OleDbDataReader dr;
con.Open(); //This is the Line 63
dr=cmd.ExecuteReader();
//some code here
con.Close();
dr.Close();
con.Dispose();
}
catch(Exception ex)
{
lblmsg.Text="Database Error --> " +ex.Message+"stack Trace:" +ex.StackTrace;
}
}
Contacting Database: Oracle
Provider : msdaora.1
I have gone through the Microsoft website and find a solution regarding Security Setting Like assigning “Impersonate a client after authentication” permission to IWAM user. I have granted But Still Getting the Same Catastrophic Failure Error.
What may be the Reason?.
Thanks in advance
Re: CatastrophicFailure Error
I'm not sure if the issues would be the same but I'd recommend using OracleClient rather than OleDb to connect to Oracle. If you're using .NET 1.0 you can download it from Oracle. Later versions of the Framework include it as standard.