HighSeverityError

Description

Determines whether the first error or the highest severity error is reported when more than one error is raised during the connection or attempted connection to the database

Applies to

SNC SQL Native Client for Microsoft SQL Server

MSOLEDBSQL Microsoft OLE DB Driver for SQL Server

Syntax

HigSeverityError=value

Parameter

Description

value

Specifies the error to be reported when multiple errors are raised. Values are:

  • 0

    (Default) The first error raised is the reported error.

  • 1

    The error with the highest severity code is the reported error.


Default value

HighSeverityError=0

Usage

When you set this DBParm to 1, PowerBuilder chooses the error with the highest severity code to pass back to the caller.

Examples

To have PowerBuilder report the error with the highest severity code, use the following DBParm setting:

SQLCA.DBParm="HighServerityError=1"