Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SRV_DONE_ERROR - is it mandatory to set this flag whenever an error condition occurs in xproc?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-01 : 08:19:28
Chetan Raj writes "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 ?"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-01 : 12:53:55
What programming language is this?

Tara
Go to Top of Page
   

- Advertisement -