>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.

I'n not sure if is bug in VFP.

SQL Server (varchar(max))
=========================
config9         15ac-1414	EXIT  SQLColAttributes  with return code 0 (SQL_SUCCESS)
		HSTMT               0x0222EF60
		UWORD                        2 
		UWORD                        6 <SQL_COLUMN_DISPLAY_SIZE>
		PTR                0x00000000
		SWORD                        0 
		SWORD *             0x00000000
		SQLLEN *            0x0018F370 (2147483647) -- max length

[INFORMATION_SCHEMA].[COLUMNS].CHARACTER_MAXIMUM_LENGTH = -1
SQLCOLUMNS(lihdbc,"test","NATIVE") (data_type) = -1 (as TEXT data type)
SQLCOLUMNS(lihdbc,"test","NATIVE") (column_size) = 2147483647


SQL Server Native Client 11.0 (varchar(max))
===========================================
config9         15ac-1414	EXIT  SQLColAttributes  with return code 0 (SQL_SUCCESS)
		HSTMT               0x003BD3B8
		UWORD                        2 
		UWORD                        6 <SQL_COLUMN_DISPLAY_SIZE>
		PTR                0x00000000
		SWORD                        0 
		SWORD *             0x00000000
		SQLLEN *            0x0018F370 (0) -- max length

[INFORMATION_SCHEMA].[COLUMNS].CHARACTER_MAXIMUM_LENGTH = -1
SQLCOLUMNS(lihdbc,"test","NATIVE") (data_type) = 12 (as VARCHAR data type)
SQLCOLUMNS(lihdbc,"test","NATIVE") (column_size) = 0