>>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.
If it's not broken, fix it until it is.
My Blog