Raise Error problem when connecting to SQL Server through ODBC

[kctan]

Hi,

I have a VB.Net system that connect to SQL Server through ODBC. When I try to raiseerror from an IF...ELSE statement, it does not triggered the exception handling.

I have done some raise error testing at my side. Below is my finding:

1. RaiseError did not triggered exception:

       CREATE PROC xxx
       AS
         IF 1=1
           BEGIN
             raiserror (70000,15,15)
           END

2. RaiseError triggered exception:

       CREATE PROC xxx
       AS
         IF 1=1
           BEGIN
             raiserror (70000,15,15)
             raiserror (70000,15,15)
           END

       CREATE PROC xxx
       AS
       BEGIN
         raiserror (70000,15,15)
       END

Any idea why it does not work in IF...ELSE statement?

Thank you.

KC

[ck9663]

It managed to work on mine. Here's the error that returned:

 
Msg 18054, Level 16, State 1, Procedure xxx, Line 6
Error 70000, severity 15, state 15 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
 
 

Happy Coding!!!


--- CK

[kctan]

Hi ck9663,

The testing is done in Sql Server Query Windows/Pane right?
This testing works on my side too.

But when I connect VB.NET system through ODBC to SQL Server, the raise error inside IF statement does not work. No exception is triggered.

Thank you.

KC

[ck9663]

Here, read this...

Happy Coding!!!

--- CK