ANSI WARNINGS and error object
in [ASP]
|
Prev: Advanced SQL injection complete tool pack(tutorials,scanners,admin finder,shells,md5)
Next: ASP .Net AccessDataSource
From: simon on 22 Sep 2010 11:29 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
From: Bob Barrows on 22 Sep 2010 15:09 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
From: simon on 23 Sep 2010 04:09 On 22 sep., 21:09, "Bob Barrows" <reb01...(a)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
From: Bob Barrows on 23 Sep 2010 09:15
simon wrote: > On 22 sep., 21:09, "Bob Barrows" <reb01...(a)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-handling-I.html#clientside Look in SQL Books OnLine (BOL) to see the error codes and their meanings. -- HTH, Bob Barrows |