>>>>The latest SQL Server ODBC driver, which works for SQL 2014 and all prior versions, is ODBC Driver 11 for SQL Server. There is an x64 version that must be used on x64 OS versions, and installs both the 32-bit and x64 versions. Then there's an x86 version, that installs just the 32-bit version. VFP, of course, needs the 32-bit version, whether on an x64 or x32 OS version.
>>>>
>>>
>>>Thanks, but I'm really looking more for the list of which SQL ODBC drivers work correctly with VFP. I know for sure one of the later versions mangles memo fields in VFP, and I'm looking to avoid discovering these incompatibilities myself.
>>
>>We use 11 in production for perhaps 120 users. We use memo fields extensively, and there are no reported issues.
>
>This version seems to have to the memo issue - varchar(max) doesn't come down as a memo field. Switching to something like varchar(6000) works, but really sucks.

If you use cursoradapter and set the mapping to such fields to memo, it comes down nice. Still haven't found if declaring a datetime2 as T would work - in the few cases where I found that, I was just reading it, so I cast it into datetime on the SQL side.