February 4th, 2014, 07:51 AM
DATE_ADD Error in MYSQL
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.