Yes, it's VFP bug. To work around it, you've to use SQL Server 2000 ODBC driver and forget about SQL Server new features or switch to ADO.
>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!
--sb--