ERROR CONVERTING DATATYPE DBTYPE_DBTIMESTAMP TO DATE TIME

[tbrauch]

I am using SQL 7 to select and insert data into a table from Oracle via an ODBC connection. It works fine except when (as described in the documentation) the Oracle date field is less than 1/1/1753, in which case, I get ERROR CONVERTING DATATYPE DBTYPE_DBTIMESTAMP TO DATE TIME. That's fine except the field I am inserting into is a VARCHAR type not DATETIME. Apparently, there is an implicit conversion to DATETIME prior to conversion to VARCHAR ????

Any help would be appreciated.