VFP doesn't know anything about new SQL Server data types and cannot interpret them correctly with new ODBC drivers. A workaround is to use CA with ADO.


>
>We are actually using the driver "DRIVER={SQL Server Native Client 10.0};", but I decided to take a look to see what the impact would be if I used the legacy driver "DRIVER={SQL Server};".
>
>What I noticed is that we get the XML datatype in a Memo using the legacy driver, but not with the Native Client 10 driver. It is the same thing when using VARCHAR Max. Also we can't use the old legacy driver as this would mean that we could not use the SQL Server 'Date' Datatype.
>
>Very strange.
>