CynthiaCols
Programmer
REFERS ALSO TO: thread183-1380176
ERROR: Error converting data type DBTYPE_DBTIMESTAMP to datetime
If you get this error in SQL, while doing an OPENQUERY SELECT on PROGRESS tables (SQL92). Just convert each datetime field until you find the offending date field that has an unallowed date.
HOW: SELECT * INTO sqlTBLname FROM OPENQUERY(LINKEDSRVRNAME, 'SELECT { fn CONVERT("start-date", SQL_CHAR)} as STARTDATE FROM PUB."tblname" ')
After you get it into SQL, then just sort and find the offending date. It probably is some date before 1900 (01/30/1630).
ERROR: Error converting data type DBTYPE_DBTIMESTAMP to datetime
If you get this error in SQL, while doing an OPENQUERY SELECT on PROGRESS tables (SQL92). Just convert each datetime field until you find the offending date field that has an unallowed date.
HOW: SELECT * INTO sqlTBLname FROM OPENQUERY(LINKEDSRVRNAME, 'SELECT { fn CONVERT("start-date", SQL_CHAR)} as STARTDATE FROM PUB."tblname" ')
After you get it into SQL, then just sort and find the offending date. It probably is some date before 1900 (01/30/1630).