Re: Windows ODBC Driver

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