Somehow change Sql error into user friendly message

[nemaroller]

We want our webservice to return only the descriptive message part of a Sql error to the client . As it stands, we get a SOAP error, along with all the baggage.

Our exact problem:

We want the Sql Server Error : Concurrent Limit Exceeded ,
to be exactly what we show when someone tries to login at a client app.

The webservice is of course wrapping into SOAP, and we need to devise a way to simply get that original error to display to the user.

Any suggestions?

[Edneeis]

I have very limited experience working with web services and even less working with SOAP (unless the shower counts). But can't you catch the sql error and return whatever you want via the webservice call? Or is this not related to a particular method in the web service but the web service as a whole?

[nemaroller]

Unfortunately no, the WebService must raise a SoapException error... we are going to just parse the .Message for the culprit, and display that to the user. Seems like the only way to do this.

Thanks anyway.

[vbcodec]

are you using VB ? maybe I am missing something with soap but with all error happen in vb you can handle it yourself by this.

On Error GoTo KeepError

<codes here>



end <or> exit sub
KeepError:

Select Case Err.Number

Case 3027

case ...


end select


hope it helps
S. Mohammad Najafi

PS: it may happen for me that my sql string have problem or something is null inside so each one of them have specified error number that you can put into your Select case