>>>We have varchar(max) columns coming OK through SQL Pass-Through. I think there is a setting needed for this, though.
>
>You can use CURSORSETPROP('MapVarChar', .T., 0) that (counter-intuitively) enables varchar mapping at the session level for subsequent selects... but still gets varchar(max) wrong. So unless your solution relies on the older non-native client ODBC drivers, I'm all ears!
>
>Meanwhile Remote Views have always allowed you to map fields including varchar(max) fields to memo, or you can cast to TEXT in your SQL that also does the trick.
Yes, that's the setting we use, I think. I know we use DSN and I haven't looked closely lately which driver we use.
If it's not broken, fix it until it is.
My Blog