ANSI WARNINGS and error object
 

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

Re: ANSI WARNINGS and error object
 

simon wrote:
> 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.

--
HTH,
Bob Barrows

Re: ANSI WARNINGS and error object
 

On 22 sep., 21:09, "Bob Barrows" <reb01...@NOyahoo.SPAMcom> wrote:
> simon wrote:
> > 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.
>
> --
> HTH,
> Bob Barrows

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

br,Simon

Re: ANSI WARNINGS and error object
 

simon wrote:
> On 22 sep., 21:09, "Bob Barrows" <reb01...@NOyahoo.SPAMcom> wrote:
>> simon wrote:
>>> 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.
>>
>> --
>> HTH,
>> 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-handl...tml#clientside

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

--
HTH,
Bob Barrows