Stephen Frost wrote:
* Bill Todd (pg@dbginc.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