OdbcException.Source Property

Definition

Namespace:

System.Data.Odbc

Assembly:

System.Data.Odbc.dll

Package:

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

Source:

OdbcException.cs

Gets the name of the ODBC driver that generated the error.

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

Property Value

String

The name of the ODBC driver that generated the error.

Examples

The following example displays the Message, Source, and NativeError properties of the first OdbcError within the OdbcErrorCollection collection.

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

Remarks

This is a wrapper for the Source property of the first OdbcError in the Errors collection.

See also

• Handling and throwing exceptions in .NET