Error Messages

General discussion forum about all databases other than SqlBase.
prpruchnik@yahoo.com

Error Messages

Post by prpruchnik@yahoo.com » 01 Aug 2012, 20:46

Greetings,
I am using GUPTA 5.1 SP6 Build 14543 with SqlServer 2008
When I get an error and use SqlGetError or SqlGetErrorTextX or SqlGetErrorTextX – I get a message that appears to be two messages and the second message truncated – an example follows:
Microsoft SQL Server:8152[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.Microsoft SQL Server:3621[Microsoft][ODBC SQL Server Driver][SQL Server]The sta
Has anyone encountered this? Is there a way to retrieve the full message of concatenated messages?
Thanks in advance,
Gupta Vet!

Jeff Luther

Re: Error Messages

Post by Jeff Luther » 01 Aug 2012, 21:45

8152: as you show:
http://www.mombu.com/microsoft/sms-admi ... 37575.html

3162: down the page a bit:
http://www.lcard.ru/~nail/sybase/error/26595.htm
Error 3621
Severity Level
10
Error Message Text
Command has been aborted.

Explanation
This error occurs when SQL Server is unable to complete a command. Error 3621 may be the last message displayed by your application even though another message was sent by SQL Server when the error actually occurred. The rest of the commands in the transaction will complete normally.
I've not seen this double-error issue before, but maybe truncation of 2nd error is a side-effect of the fact that it's been 'aborted.' My suspicion is that the first error is the 'real' one -- from TD perspective -- and in your case sounds like possible a Unicode issue?

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests