>>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.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.