ADO and RAISERROR
Posted on 2003-12-11
I have application that connects to MS SQL 2000 using ADO. I’m trying to handle multiple errors returned from store procedures. Everything works OK if I do not have cursor inside my store procedure. Once cursor is reached ADO driver fly out and I do not get rest of the error or record set. Just to be clearer here is the example of what happens:
In case of code like this:
-- other code
In my app I m able to get all 3 errors and record set
I’m getting only error 1 and 2 but not error 3 or record set after cursor.
Any suggestions are really appreciated