OleDbException Classe

Definição

public ref class OleDbException sealed : System::Data::Common::DbException

public ref class OleDbException sealed : System::Runtime::InteropServices::ExternalException

public sealed class OleDbException : System.Data.Common.DbException

[System.Serializable]
public sealed class OleDbException : System.Runtime.InteropServices.ExternalException

[System.Serializable]
public sealed class OleDbException : System.Data.Common.DbException

type OleDbException = class
    inherit DbException

[<System.Serializable>]
type OleDbException = class
    inherit ExternalException

[<System.Serializable>]
type OleDbException = class
    inherit DbException

Public NotInheritable Class OleDbException
Inherits DbException

Public NotInheritable Class OleDbException
Inherits ExternalException

Herança

Object

Exception

SystemException

ExternalException

DbException

OleDbException

Herança

Object

Exception

SystemException

ExternalException

OleDbException

Atributos

SerializableAttribute

Exemplos

O exemplo a seguir gera um OleDbException devido a uma fonte de dados ausente e exibe a exceção.

public void ShowOleDbException()
{
   string mySelectQuery = "SELECT column1 FROM table1";
   OleDbConnection myConnection =
      new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=");
   OleDbCommand myCommand = new OleDbCommand(mySelectQuery,myConnection);

   try
   {
      myCommand.Connection.Open();
   }
   catch (OleDbException e)
   {
     string errorMessages = "";

     for (int i=0; i < e.Errors.Count; i++)
     {
         errorMessages += "Index #" + i + "\n" +
                          "Message: " + e.Errors[i].Message + "\n" +
                          "NativeError: " + e.Errors[i].NativeError + "\n" +
                          "Source: " + e.Errors[i].Source + "\n" +
                          "SQLState: " + e.Errors[i].SQLState + "\n";
     }

     System.Diagnostics.EventLog log = new System.Diagnostics.EventLog();
     log.Source = "My Application";
     log.WriteEntry(errorMessages);
     Console.WriteLine("An exception occurred. Please contact your system administrator.");
   }
}

Public Sub ShowOleDbException()
    Dim mySelectQuery As String = "SELECT column1 FROM table1"
    Dim myConnection As New OleDbConnection _
       ("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=")
    Dim myCommand As New OleDbCommand(mySelectQuery, myConnection)

    Try
        myCommand.Connection.Open()
    Catch e As OleDbException
        Dim errorMessages As String
        Dim i As Integer

        For i = 0 To e.Errors.Count - 1
            errorMessages += "Index #" & i.ToString() & ControlChars.Cr _
                           & "Message: " & e.Errors(i).Message & ControlChars.Cr _
                           & "NativeError: " & e.Errors(i).NativeError & ControlChars.Cr _
                           & "Source: " & e.Errors(i).Source & ControlChars.Cr _
                           & "SQLState: " & e.Errors(i).SQLState & ControlChars.Cr
        Next i

       Dim log As New System.Diagnostics.EventLog()
       log.Source = "My Application"
       log.WriteEntry(errorMessages)
       Console.WriteLine("An exception occurred. Please contact your system administrator.")
    End Try
End Sub

Comentários

Essa classe é criada sempre que o provedor de dados .NET Framework para OLE DB encontra um erro gerado do servidor. (Os erros do lado do cliente são gerados como exceções padrão do Common Language Runtime.) OleDbException sempre contém pelo menos uma instância de OleDbError.

Se a severidade do erro for muito grande, o servidor poderá fechar o OleDbConnection. No entanto, o usuário pode reabrir a conexão e continuar.

Para obter informações gerais sobre como lidar com exceções para um provedor de dados .NET Framework, consulte SqlException.

Propriedades

Métodos

Eventos

Aplica-se a

Confira também

• OleDbErrorCollection
• Tratando e gerando exceções no .NET