Hi,

I have connected a MY SQL database in MS SQL Server through Linked Server.

select * from openquery(MYSQL,'SELECT DATE_ADD(''2008-01-02'', INTERVAL 1 DAY);');

While executing the above query, I'm getting the below error message.
OLE DB provider 'MSDASQL' for linked server 'MYSQL' returned data that does not match expected data length for column '[MSDASQL].DATE_ADD('2008-01-02', INTERVAL 1 DAY)'. The (maximum) expected data length is 29, while the returned data length is 10.

Please help me how to resolve this issue.