I need a work around for this flipping error. I am using odbc to connect to
a foxpro freetable and copy fields to a MSSQL2000 table.
The fox table has 5 different date fields in it. There is no constraint on
these fields...it doesn't care if a value is in it or not. It does not
allow nulls either.
The date field in fox is a DateTime, the Date Field in MSSQL is datetime,
Anyway it is a pretty straight forward deal....just copy all from fox to
sql. About half way thru the jopb it errors out with:
Insert error, (Fieldname),DBTYPE_DBTIMESTAMP, status 6 Data Overflow
Invalid character value for cast specification