>I know this is .net but as an aside for people using vfp remote views it is worth noting that among the frailties of the VFP 9 view designer is a failure to see SQL varchar(max) fields as Memo and instead setting them by default to C(0). Attempting to save the view causes it to barf. You can view the code, change the dbsetprop type and all is well. Annoying nonetheless.
>

It is not the only datatype that fails when you use ODBC driver. Casting or using ADO are workarounds too.
Cetin