[VOPRadius] KB Article: Arithmetic overflow error converting expression to data type int

[Suneel Jhangiani]

Title: Message

I’m not sure how long it would be before Brad reads the response you posted, but I would take offense at your third comment.   Firstly, I understand that you are not a native English speaking person, and hence can forgive the translation ‘our customer people’ and would read that as ‘our support people’ (I certainly hope you didn’t mean customers here). Secondly, Brad’s enquire was a request as to whether or not Vircom VOP Radius still supports integration with Rodopi, and in my opinion as long as it still allows Rodopi to be selected as an Authentication source then it should.   I do agree that the Stored Procedures are not under Vircom’s control and that Brad needs to contact Rodopi regarding this error, but the response should have stated such.   As you are a ‘Development Lead’ I would also think that you understand what is wrong here, which I would presume is Rodopi trying to convert the Octets numeric value to an integer before turning it into KB or MB. What the stored procedure should do is work on it as a numeric value throughout and only convert it to an Int at the end for display purposes, this would also result in the display data being more accurate.   Don’t get me wrong, I’m not trying to criticize anyone here, just suggesting that maybe your post was a little hasty.   Regards,   Suneel.     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sylvain Savignac Sent: Thursday, December 02, 2004 7:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [VOPRadius] KB Article: Arithmetic overflow error converting _expression_ to data type int   Hello Brad,   First VOP Radius does support Rodopi. Second it means that the value of Acct-Output-Octets namely 2093965588 is too big for your ODBC SQL Server Driver. (Look at its version maybe and on Microsoft web site for info ...) Third our customer people would have been able to help you instead of shooting in the dark on the VOP Radius mailing list.   These Knowledge Base articles that we have been put up lately on our web site are there to try to help us and our customers to debug faster...   Regards,   Sylvain Savignac, P. Eng.   Development Lead RADIUS Development Unit Vircom Inc.   2055, Peel St, suite 200 Montr�al (Qu�bec) Canada H3A 1V4 www.vircom.com