>>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.