[freetds] Issue with return status from stored procedure with awarning message.

Reid, Roger L. roger.reid at dpw.com
Tue Jan 9 10:02:44 EST 2007


I do a lot more db-lib than ct-lib, but isn't it up to the error handler
in your app to ignore that severity/error combo and pass control back to
the
point immediately after the error was generated?   

app calls sp
sp generates error
control goes to apps error handler
error handler says 
	for that error/severity 
		return 0
control passes back to next line of your sp

Or have I done my usual complete misunderstanding of your question and
issue?

roger reid (not a freetds guru, just a long time user) 

> -----Original Message-----
> From: Glenn, Chris 
> Sent: Tuesday, December 19, 2006 2:23 PM
> To: 'freetds at lists.ibiblio.org'
> Subject: Issue with return status from stored procedure with a warning
> message.

> When the 'begin tran' is executed, an error code 266 is generated
> (Transaction count after EXECUTE indicates that a COMMIT of ROLLBACK
> TRANSACTION statement is missing...) with a severity level of 16.
> According to Microsoft's documentation (link below), this 
> error code is
> just a warning message and can be ignored.
> http://msdn2.microsoft.com/en-us/library/aa258721(SQL.80).aspx
> 
> What appears to be happening is that the return status is never
> processed and passed back to my CT-Lib application (I assume) 
> because of
> the error code 266.
> 
> I've attached the excerpt from the debug log when calling the stored
> procedure with the 'begin tran' mode and without.
> 
> Chris Glenn
>  <<SP with begin trans.txt>>  <<SP without begin trans.txt>> 
> 


More information about the FreeTDS mailing list