Unanswered: MSSQL 7 linked to DB@ Date/Time problem
I'm using what i presume to be the latest ODBC iSeries driver for Windows, and using this to connect to the AS 400 from MS SQL Server 7.
The problem I'm having is that once I've linked the table and start perform queries, certain field values are aborting my queries. I've discovered that the problem is that DB 2 accepts dates from 0001/01/01 and SQL server 7 only starts at around 1790/01/01. SQL Server obviously discovers that the field data type on the DB2 is Date and attempts to import the values as such, then with 0001-01-01 as the value, I'm politely told by SQL server to get stuffed.
If anyone knows of a way to work around this problem without actually changing the dates in the source DB, I would greatly appreciate their help.