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?