>>
>>In order to use SQL Server 2008 Date data type, you have to access it with SQL Server 2008 Native client but it doesn't work well with VFP.
>
>But if you do not use Date type in SQL Server 2008 it will work well with VFP via ODBC?

It depends on which ODBC driver you use. SQL 2000 ODBC driver works correctly with varchar(MAX) but you cannot access any other new data types with it. The SQL Server 2005/2008 Native client doesn't work correctly from VFP with with varchar(MAX)