ANSI WARNINGS and error object

[simon]

Hi,

I'm using err.number to check if there is some error when executing
stored procedures on sql database.
But if sql returns ANSI WARNINGS, that is always error to asp, err
object is not empty.
I can't set ansi warnings to off on sql server because I have indexed
views, filtered indexes,....

I must check this on asp side - any idea?

Thank you,
Simon

 

[Bob Barrows]

Hi,

I'm using err.number to check if there is some error when executing
stored procedures on sql database.
But if sql returns ANSI WARNINGS, that is always error to asp, err
object is not empty.
I can't set ansi warnings to off on sql server because I have indexed
views, filtered indexes,....

I must check this on asp side - any idea?

Nothing beyond parsing them to see if they are warnings and if so,
ignore them.

 

[simon]

Nothing beyond parsing them to see if they are warnings and if so,
ignore them.

Thank you.
Do you know maybe if err.number is some specific for ansi warnings?

br,Simon

 

[Bob Barrows]

Thank you.
Do you know maybe if err.number is some specific for ansi warnings?

Yes, it very likely is, especially if the NativeError property of the
connection's Error object is set by the error. Unfortunately, this is
not always provided. See:
http://www.sommarskog.se/error-handling-I.html#clientside

Look in SQL Books OnLine (BOL) to see the error codes and their
meanings.