Bob,

I was reading the sql books on-line and it says:

If the data to be stored is longer than number of characters allowed, 
the data is truncated. For example, if a column is defined as char(10)
and the value “This is a really long character string” is stored into 
the column, Microsoft® SQL Server™ truncates the character string 
to “This is a”.

Maybe the column giving the error is not a Char() field. I noticed the view has the sql timestamp column in the view, but it is not updated. Maybe I will try removing that field from the view.

Have you seen this error before in sql*server?

Thanks,

Kevin




Its the same problem. Trying to send more characters to the column than it is defined for will spawn this error.

>Hello,
>
>I have a user reporting an ODBC error:
>
>
Connectivity error: [Microsoft][ODBC SQL Server Driver]
>String data,right truncation
>
>I have seen truncation errors in Oracle (trying to out 50 characters in a 40 character field), but I have never seen this in SQL*server. I searched MSKB and Google for this error and nothing came up that fit the scenario.
>
>VFP6 SP5 remote view with SQL2000.
>
>Any ideas?
>
>Thanks,
>
>Kevin