Problem:

Error occurs  on select and insert of data via OpenEsql to sqlserver.

String data, right truncation (SQLCODE 000000001)

Running SQLServer 2000.  Datadirect ODBC64 v 53.

Resolution:

Correct by using OpenESQl in 32 bit mode with Datadirect 32 bit ODBC data sources

Server Express currently support OpenESQL in 32-bit mode,....to providing support for accessing 64-bit ODBC data sources from OpenESQL will be within the SX 5.1 timeframes. There is no commitment date at this time