Err Raise in SQL to VB

[Micke101]

hello

I am trying to do an erroraise from sql server in a stored procedureto vb and then
show it to the user, but I cant get it together.
anybody with an idea.

thanks Micke

[Clunietp]

Hi

Stored Procedure:

CREATE PROCEDURE spu_test 

AS

RaisError ('THERE WAS AN ERROR', 15, 1)

VB:

Private Sub Form_Load()
    
    On Error GoTo Err_Handler
    
    Dim cn As New Connection
    
    cn.Open <ConnectionString>
    
    cn.Execute "spu_test"
    
    Exit Sub
    
Err_Handler:
    MsgBox Err.Description
    
End Sub

This will raise an error from the SQL Stored Proc and pass it back to the client for handling