>Apperently there is a bug in one of the Microsoft layer: VFP9SP2->SQLNativeClient->SQLServer(2008) when attemting to read a column with datatypes varchar(max) or varbinary(max) from SQLServer 2008/2005 via SQLNativeClient. The problem is that VFP9 (SP2) creates a cursor with column varchar(0), which a) has no data and b) is definitely a datatype which cannot be used (varchar with length 0 are illegal in VFP.
>
>Everything works propertly with ODBC instead of SQLNativeClient.
>
>Does anyone have solution?
>
>Thank you in advance!
This problem was discussed here before, check message #
1381889 and the whole thread.
If it's not broken, fix it until it is.
My Blog