#28 64-bit ODBC Failure: (22001) [Microsoft][ODBC SQL Server Driver]String data, right truncation

[RodD]

Since upgrading to the 64-bit Windows ODBC version of RexxSql with Open Object Rexx, I get frequent failures as follows:

(22001) [Microsoft][ODBC SQL Server Driver]String data, right truncation

These failures seem to be random & can often be circumvented by a little rearranging of the sequence of calls to RexxSql. But there is no consistency and what works today may fail tomorrow on exactly the same database.

The exact same code never fails using the 32-bit Windows Open Object Rexx and the 32-bit RexxSql. Unfortunately I really need to use the 64-version of Open Object Rexx, so it's a real showstopper.

I have seen this failure in ooRexx 4.0, 4.1, and currently on 4.2.