Catching exception of System.Data.OleDb.OleDbException type

[Nits]

Hello All,

I wanted to know what kind of exceptions will be catched in the class
type of
System.Data.OleDb.OleDbException

I was expecting the database constraints violations errors will fall
into this type
of exception handling, but it doesnt seem so. And if it cannot catch
these exceptions
then what type will catch database constraints violations errors ?

Thanks,
Nitin.

 

[Miha Markic [MVP C#]]

Are you using OleDb managed provider?

 

[nitinvraj]

I am using OleDbConnection object and Oracle Provider for OLE DB

The connection string is like this

"Provider=OraOLEDB.Oracle.1;Password=password;
Persist Security Info=True;User ID=User;Data Source =DS;"

Nitin.

 

[Miha Markic [MVP C#]]

Try setting a catch block that catches all exceptions and see what type are
they, like:
try
....
catch (Exception ex)
{
// ... check ex's type here
}
An observations: Why don't you use managed Oracle provider?

 

[nitinvraj]

you mean I should use

System.Data.OracleClient.OracleConnection object ?

Nitin.

 

[Miha Markic [MVP C#]]

Sure, why not if you are dealing with Oracle.