
01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right truncation
I get this error when using an Access97 pass-thru query to call a stored
procedure on SQL 6.5. It returns a memo field. When I exclude the memo
field the error disappears. There seems to be some known issues with memo
fields in SQL calls. But, I haven't found any resolution other than
disabling the "log messages" property of the pass-thru query.
Should I ignore this error and disable the log. Or is there a solution to
fix the problem?
- Jon