Error handling

The SAP Sybase IQ .NET Data Provider creates an SAException object and throws an exception whenever errors occur during execution. Each SAException object consists of a list of SAError objects, and these error objects include the error message and code.

Errors are different from conflicts. Conflicts arise when changes are applied to the database. Your application should include a process to compute correct values or to log conflicts when they arise.

C# error handling example

The following C# code creates a button click handler that opens a connection to the SAP Sybase IQ sample database. If the connection cannot be made, the exception handler displays one or more messages.

private void button1_Click(object sender, EventArgs e)
{
    SAConnection conn = new SAConnection("Data Source=Sybase IQ Demo");
    try
    {
        conn.Open();
    }
    catch (SAException ex)
    {
        for (int i = 0; i < ex.Errors.Count; i++)
        {
            MessageBox.Show(ex.Errors[i].Source + " : " +
             ex.Errors[i].Message + " (" +
             ex.Errors[i].NativeError.ToString() + ")",
             "Failed to connect");
        }
    }
}

Visual Basic error handling example

The following Visual Basic code creates a button click handler that opens a connection to the SAP Sybase IQ sample database. If the connection cannot be made, the exception handler displays one or more messages.

Private Sub Button1_Click(ByVal sender As System.Object, _
     ByVal e As System.EventArgs) Handles Button1.Click
    Dim conn As New SAConnection("Data Source=Sybase IQ Demo")
    Try
        conn.Open()
    Catch ex As SAException
        For i = 0 To ex.Errors.Count - 1
            MessageBox.Show(ex.Errors(i).Source & " : " & _
              ex.Errors(i).Message & " (" & _
              ex.Errors(i).NativeError.ToString() & ")", _
              "Failed to connect")
        Next i
    End Try
End Sub