Products Resources Support About Us

Rocket Software

OLE DB provider 'MSDASQL' for linked server 'test_odbc' returned data that does not match expected data length for column

When I run this ODBC query against TEST (and some other logons), we get the following error:

select top 1000 * from openquery(test_odbc,‘SELECT * FROM ACCOUNT’)

OLE DB provider ‘MSDASQL’ for linked server ‘test_odbc’ returned data that does not match expected data length for column ‘[MSDASQL].LENTEST’. The (maximum) expected data length is 254, while the returned data length is 1016.

Don’t know how to solve this. I am new to U2. Can someone help?