>>>>Hi!
>>>>
>>>>>What is your connection string? With the latest SQL Server driver you'll get this problem.
>>>>I've tested all Versions of the SQL Native Clients (2005, 2008 and 2012) an in all these Versions the varchar(max) Memos from the SQLExec Command get the lengh 0.
>>>>
>>>>Only with the SQL 2000 Driver it works. Bud with the SQL2000 Driver there a some other Problems...
>>>>
>>>>Any suggestions?
>>>
>>>Well, unfortunately, it's a bug and the options are limited. Try to search here, this question was discussed in a past.
>>
>>the bug is this:
>>VFP uses ODBP parameter SQL_SS_LENGTH_UNLIMITED = 0 as zero, don't as unlimited!
>>
>>Too bad that is not solved, it does not require a lot of work.
>
>Do you know of any workaround?

No. I use text and image fields on odbc data.