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.

hth,

Hank

ref: https://msdn.microsoft.com/en-us/library/cc280510.aspx

>I used to have a list of the versions of the SQL Server ODBC drivers that worked with VFP (and what worked/didn't work). I know some versions work OK, but don't support Date fields, another version supports Date but varchar(max) fields get messed up, etc. However, I can't seem to find it anymore.
>
>I normally just connect using the "SQL Server" client, which has always worked in the past, but now I'm bumping into a feature I need from a later driver but I don't want to get burned with an unexpected incompatibility.
>
>Anyone have a list of them and what works/doesn't work?