>Getting the message 'String or binary data would be truncated.' when I try to save an updated remote view back to SQL Server.
>
>Only one field in the view is set to Updateable and that field is defined as decimal (15,2) in SQL Server. The view, as initially set in ViewEditor, had the field defined as N(17,2). I changed it to N(15,2) and still got the error. I also tried N(10,2) and, after Del Lee pointed out that SQL Server doesn't count the decimal in the length of the field, N(16,2). In all cases I get the same error and the table isn't updated.
>
>Can anyone suggest what else I should be checking?
>
>TIA

For anyone following this thread, the problem was in my connection string. Changing 'UseTrustedConnection=yes' to 'UseTrustedConnection=no' allowed my app to update the table with no problems.

Regards,