RE: There's an error, but $sth->execute returns -1

[email protected] ("Roode, Eric")
Newsgroups perl.dbi.users
Message-ID <[email protected]>
On Monday, October 18, 2010 12:27 PM, Martin J. Evans wrote:
[...]
> I looked at this some more and I'm even more sure it is a bug.
> 
> The TDS protocol for your situation returns:
> 
> tds_error - failed to insert null
> tds_info  - statement has been terminated
> a load of done_procs
> the return argument of your procedure containing error in add feed
> 
> I think the driver is seeing the error but then its idea is
> overidden by the tds_info packet. Later native client drivers (and
> our driver) see exactly the same but they acknowledge the tds_error
> as being the final state and don't override it with the tds_info.
> 
> BTW, the state returned is 23000 so you might be able to look at
> that (in $sth->state). I thought you might also be able to look at
> the return of your procedure but that is not possible. You could
> also perhaps do something with the odbc_err_handler.

Thanks, Martin.

What is this TDS and where can I learn more about it?

-- Eric
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.