>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.
>
Thanks. I have suspected a data problem, but have not been able to track it down.
Is there a way (other than trial and error) to determine which column/field is the problem? There are over 120 columns in this particular view, although only 3 are memo fields (which *must* translate to varchar). Thanks for the input.
- Bruce
>-Mike
"Problems cannot be solved at the same level of awareness that created them." - Albert Einstein
Bruce Allen
NTX Data