sql server connect: SRV_DONE_ERROR - is it really mandatory ? -- sql server connect

SRV_DONE_ERROR - is it really mandatory ?

Chetan Raj
9/30/2003 3:54:01 AM

sql server connect: hi,

we are using sqlclient to connect to DB from app code.
When ever there is an error we set the SRV_DONE_ERROR falg
in srv_senddone & we also send the result-set.

now sqlclient throws an exception whenever there is an
error ( when SRV_DONE_ERROR flag is set ) and does not
allow us to process the resultset.

if the error is not fatal, we want to proceed with the
resultset.

So whats the work around? is it mandatory to set the
SRV_DONE_ERROR flag? Cannot we just return the XP_ERROR (
or any error code ) without seting the SRV_DONE_ERROR
flag ?

Re: SRV_DONE_ERROR - is it really mandatory ?

Gert E.R. Drapers
9/30/2003 1:46:22 PM

If you want the result set to be processed don't send the SRV_DONE_ERROR,
but now your XP code usage will be depending on return codes which is a
design question if you want this or not.

GertD@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.

[quoted text, click to view]