OdbcException Sınıf

Tanım

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

public ref class OdbcException sealed : SystemException

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

[System.Serializable]
public sealed class OdbcException : SystemException

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

type OdbcException = class
    inherit DbException

[<System.Serializable>]
type OdbcException = class
    inherit SystemException

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

Public NotInheritable Class OdbcException
Inherits DbException

Public NotInheritable Class OdbcException
Inherits SystemException

Devralma

Object

Exception

DbException

OdbcException

Devralma

Object

Exception

SystemException

ExternalException

DbException

OdbcException

Devralma

Object

Exception

SystemException

OdbcException

Öznitelikler

SerializableAttribute

Örnekler

Aşağıdaki örnek, bir OdbcException eksik veri kaynağı nedeniyle bir hata oluşturur ve özel durumu görüntüler.The following example generates an OdbcException because of a missing data source, and then displays the exception.

public void ShowOdbcException()
{
   string mySelectQuery = "SELECT column1 FROM table1";
   OdbcConnection myConnection =
      new OdbcConnection("DRIVER={SQL Server};SERVER=MyServer;Trusted_connection=yes;DATABASE=northwind;");
   OdbcCommand myCommand = new OdbcCommand(mySelectQuery,myConnection);
   try
   {
      myCommand.Connection.Open();
   }
   catch (OdbcException 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.ToString() + "\n" +
                          "Source: " + e.Errors[i].Source + "\n" +
                          "SQL: " + 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 ShowOdbcException()
    Dim mySelectQuery As String = "SELECT column1 FROM table1"
    Dim myConnection As New OdbcConnection _
       ("DRIVER={SQL Server};SERVER=MyServer;Trusted_connection=yes;DATABASE=northwind;")
    Dim myCommand As New OdbcCommand(mySelectQuery, myConnection)
    Try
        myCommand.Connection.Open()
    Catch e As OdbcException
        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.ToString() & ControlChars.Cr _
                           & "Source: " & e.Errors(i).Source & ControlChars.Cr _
                           & "SQL: " & 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

Açıklamalar

Bu sınıf, OdbcDataAdapter sunucu tarafından oluşturulan bir hatayla karşılaştığında oluşturulur (istemci tarafı hataları standart ortak dil çalışma zamanı özel durumları olarak tetiklenir.).This class is created whenever the OdbcDataAdapter encounters an error generated by the server (Client-side errors are raised as standard common language runtime exceptions.). Her zaman en az bir örneği içerir OdbcError .It always contains at least one instance of OdbcError.

Hatanın önem derecesi çok harika ise, sunucu kapatılabilir OdbcConnection .If the severity of the error is too great, the server may close the OdbcConnection. Ancak, Kullanıcı bağlantıyı yeniden açabilir ve devam edebilir.However, the user can reopen the connection and continue.

.NET Framework veri sağlayıcısı için özel durumları işleme hakkında genel bilgi için bkz SqlException ..For general information about handling exceptions for a .NET Framework data provider, see SqlException.

Özellikler

Yöntemler

Ekinlikler

Şunlara uygulanır

Ayrıca bkz.

• OdbcErrorCollection
• .NET 'te özel durumları işleme ve atmaHandling and throwing exceptions in .NET