Re: Windows ODBC Driver

Stephen Frost wrote:
> * Bill Todd (pg(at)dbginc(dot)com) wrote:
>
>> FWIW I cannot get the ODBC driver to work correctly with ADO and the OLE
>> DB provider for ODBC. It sees TEXT fields as VARCHAR instead of
>> LONGVARCHAR. I do not know if the problem is at the ODBC level or the
>> ADO level but test carefully if you are going to use TEXT fields.
>>
>
> There's an option in the ODBC configuration settings to flip that back
> and forth, I believe... 'Text as LongVarChar'.
>
> Stephen
>
Been there, done that, does not work.<g> The only way I could get a text
field to be treated as LongVarChar was to check UnknownAsLongVarChar and
when I do that both VarChar and Text columns are treated as LongVarChar.

Bill