CatastrophicFailure Error

[srinivas_chakka]

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:

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

[jmcilhinney]

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.