แก้ไข

แชร์ผ่าน


OdbcException.Source Property

Definition

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

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.

Applies to

See also