>>SQL Server native client 11.0 is not working correctly with varchar(max) column. I think that was the reason we used that driver. However, I think ODBC driver (the latest version) should work for us (it seems to be working correctly for varchar(max) and we're not using date columns, so we should be OK).
>
>SQL Server native client 11.0 is working correctly with varchar(max), probably you meant the other way (SQL Server driver not working correctly with many newer data types including varchar(Max)).
>
>PS: Problem is with using ODBC, try using OLEDB instead (it will not be supported in future SQL versions but that is more reliable to be used from VFP).

Found this thread which is a bit old:

https://support.west-wind.com/Thread4761F6U59.wwt

I'm guessing we would need to re-test - we're using DSN for our connections.