Further testing has revealed that adding UnknownAsLongVarchar=1 to the
connection string causes ADO to see TEXT fields as LongVarchar but it
also causes all VARCHAR fields of any size to be seen as LongVarChar.
Why is ADO or the ODBC driver seeing all Varchar and Text fields as
type unknown?
--
.Bill.