Thanks for the pointer.
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.
>My guess is that you're using SQL 2000 ODBC driver that does not support new data types. See Message ID:
1381939>
>>
>>Anyone had any luck using the SQL Server XML Datatype inside VFP?
>>
>>We use ODBC SQL Pass through to connect manipulate data in an SQL Server 2008 database. If we select data from a table that has a column of 'XML' datatype, the cursor column is empty in VFP.
>>
>>What do we need to do to get the XML into a VFP Memo datatype?
>>
>>Regards
>>
>>Macer