We are still using the SQL Server driver and it seems its version is rather new in Windows 10. We did not observe any problems using this driver.
Of course, encryption will require different driver.

Here is a fix for varchar(max): http://baiyujia.com/vfpcompiler/en/default.asp (Fix 46)

Another problem seems to be to recognize the driver which is currently in use. Does exist some function which would return the driver name to the client app?

P.C.