OdbcException.Source Propriedade

Definição

Namespace:

System.Data.Odbc

Assembly:

System.Data.Odbc.dll

Pacote:

System.Data.Odbc v9.0.0-rc.2.24473.5

Obtém o nome do driver ODBC que gerou o erro.

public:
 virtual property System::String ^ Source { System::String ^ get(); };

public override string Source { get; }

member this.Source : string

Public Overrides ReadOnly Property Source As String

Valor da propriedade

String

O nome do driver ODBC que gerou o erro.

Exemplos

O exemplo a seguir exibe as Messagepropriedades , Sourcee NativeError do primeiro OdbcError dentro da OdbcErrorCollection coleção.

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 errorMessage = "Message: " + e.Message + "\n" +
                           "Source: " + e.Source;

     System.Diagnostics.EventLog log = new System.Diagnostics.EventLog();
     log.Source = "My Application";
     log.WriteEntry(errorMessage);
     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 errorMessage As String = "Message: " & e.Message & vbCrLf & _
                                     "Source: " & e.Source

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

Comentários

Esse é um wrapper para a Source propriedade do primeiro OdbcError da Errors coleção.

Confira também

• Tratando e gerando exceções no .NET