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