>>>Hi Tore,
>>>
>>>we use varchar(max) without a problem. We map types in the DBC (we use remote views). This can be done for cursoradapters as well (as one would expect, given that the same mechanisms are at work).
>>>
>>>Hank
>>>
>>We're using SqlExec command and thus we can not use the new driver unless you have ideas.
>
>when you read data, convert it to text within sqlexec script
>CAST(varcharmaxField AS TEXT)
That's an interesting idea. I will keep it in mind if Microsoft actually removes support for Text fields. However, when the support for Text fields stops, most likely you can't Cast to Text either. So far I can live with Text fields.
Since their first "warning" that Text field support will be stopped in a later version is way back in time, with nothing happening so far, I doubt that it will happen during the lifetime of my applications.