>>>Try with the newer driver. If I remember correctly, the newest driver works with DATE type, but has problems with varchar(max). The oldest driver works with varchar(max) but doesn't work with DATE type.
>>
>>Where can i find that driver?
>
>This is what I have for SQL Server drivers. I have SQL Server 2014 installed locally.
>Check which drivers do you have (run odbcad32.exe from Windows/SysWow64 directory.

Updated to 11.0 still no joy

What version do you have for the "SQL Server" driver? i can't see in the pic you sent