Re: missing divide by zero error

"Thompson, William" <[email protected]> Fri, 16 Sep 2016 07:45:24 +0000
Newsgroups gmane.comp.db.tds.freetds
Message-ID <4A990489BF566041A7724DC577BB060417F58903@smtp_mail.bankofamerica.com>
Hi Adam,

I see from the log  that you are using the db-library API.
If you want to handle error messages from the server using db-library you will have to define a message handler, using the db-library function dbmsghandle()

Here's a link to a (Sybase) resource describing the function. A search on dbmsghandle will point you to much more. 

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ocs_12.5.1.dblib/html/dblib/CBAJCDEA.htm

HTH,

Bill

-----Original Message-----
From: FreeTDS [mailto:[email protected]] On Behalf Of Adam Baratz
Sent: 14 September 2016 21:50
To: FreeTDS Development Group
Subject: [freetds] missing divide by zero error

I'm running into an issue where a "SELECT 1/0" query returns a NULL result instead of an error. I attached the relevant snippet from the TDSDUMP output (the packet continues with some host information). The result is coming back as TDS7_RESULT instead of ERROR, but part of it includes the error message. I took a look at the appropriate spec[1], but I'm having trouble understanding the format. Does anyone have thoughts on what's going on? I'm using MSSQL with TDS 7.2.

Thanks,
Adam

---
[1] http://www.freetds.org/tds.html#t129

----------------------------------------------------------------------
This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer.   If you are not the intended recipient, please delete this message.