>>>Cetin - this is the message I was referring to. SQL Native Client was definitely not returning memo field data in views filled with SPT. This was in VFP 9 and sql2005 and it had us going crazy for quite a while until someone suggested we switch to the ODBC driver.
>>>
>>Charles,
>>
>>Does the problem with varchar(max) exist in VFP 9 SP2 latest hotfix and OleDB?
>>
>>Also, what you're using for varbinary(max) and how does it work with ODBC vs. OleDB ?
>>
>>Thanks in advance.
>
>Sorry, I don't know. I don't use VFP anymore except to maintain apps I wrote for clients. Haven't tried any hotfixes etc. and don't even know if OleDB works with SQL 2008 R2.
May be someone else wants to share the experience. I think there were recent threads in regards of varchar(max) and OleDB, but quick search here only found this thread.
If it's not broken, fix it until it is.
My Blog