>>I can't remember all the details, but I seem to recall issues with dates, varchar(max), xml not being propagated to FoxPro.
>
>Right, varchar(max) does not work with the Native SQL driver (10 and 11). You need to use Text columns instead.
>
>Simple date column works with Native (10 and 11), but comes across as a string in the SQL ODBC driver. It looks like a date, but your code will barf on it.
>
>SQL ODBC driver works with Datetime and Smalldatetime and varchar(Max).
>Native 10 and 11 driver works with Datetime and Smalldatetime and Date.

And in SQL2012 there's a datetime2 with resolution to milliseconds (or better, don't remember how many decimals I saw), which comes down as string (c(20) IIRC) unless I cast it as old datetime.