Yes, SP1 is current update, but it isn't clear why SQL 2000 driver converts varchar(max) better than SQL Native Client, since this is a new data definition.




>>Hello,
>>
>>I have found an issue in order to convert varchar(max) from SQL 2005 database to Fox memo fields.
>>
>>Database is created on SQL server 2005, and a given table has varchar(max) fields, but:
>>
>>When using VFP8 , SQL Server 2000 driver and SQLEXEC , the varchar(max) is well converted to memo field.
>>
>>When using VFP8 , SQL Server 2005 Native Client driver and SQLEXEC , the varchar(max) is converted to Char(0) . Zero length.
>>
>>If I open the same table through cursor adpaters, field mapping is OK.
>>
>>I need to continue to use VFP8 SP1 and SQL 2005 Native Client, What do I need to update or configure?
>>
>>Thanks,
>>Juan C.
>
>Did you try to upgrade to SQL Server 2005 SP1?