Bruce,
> [1,2] C "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server] Arithmetic overflow error converting numeric to data type varchar."
SQL Server is trying to do any implicit conversion from a numeric data type (such as an integer) to a varchar data type. The most likely problem is that the varchar is too small.
I would check your remote view. The data type property must be set to the wrong value.
-Mike