March 31, 2009 at 3:08 pm
user gets the error below when running from the application
"[8152] [1] [0] "[Microsoft][SQL Native Client][SQL Server]String or binary data would be truncated"
it is just an update statement.It works fine when running from the management studio.i did find some articles on this error but those were in reference to the errors from management studio..recently this db was migrated from 2000. On other environments works fine..I am confused whether it is sql issue or app server issue. Please suggest me..thanks
March 31, 2009 at 3:38 pm
Hi,
please check the length of the string you are passing to the database.
If you have a table with a VARCHAR(10) field and pass the string '1234567891011' you get this error message.
Regards.
-----------------------
SQL Server Database Copy Tool at Codeplex
March 31, 2009 at 4:18 pm
it is just updating with "0: as the data...it works fine from query analyzer..the error is only seen from doing from the application..thanks.
March 31, 2009 at 7:54 pm
Profile the statements(using profiler) executed by the application when it runs the update code and see what all gets executed apart from this(any other statement due to presence of triggers).
MJ
March 31, 2009 at 7:58 pm
user did try running the application by disabling the triggers...same error...my colleague ran the trace before said he cdnt find any helpfull information..ill try once again..thanks...
April 1, 2009 at 10:41 am
made some changes..tables permissions were missing..lets see if that fixes the issue..will update..thanks
April 2, 2009 at 8:49 am
no luck..still same issue...any suggestions?
April 3, 2009 at 3:42 am
Hi I have this error before - please check quat in your application update statement like "Update [tbl] SET [FLD]='test text'"
April 3, 2009 at 8:06 am
thanks for your reply..what do u mean by "quat"...thanks,
April 3, 2009 at 11:04 am
Sorry it was typo - should be quote
Thanks
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply