I am using sql server 2005 to connect to a Linked Server (DB2 database, I'm fairly sure, but not a 100%)
using the following query
SELECT * FROM OPENQUERY
( US_DATABASE ,
FROM US.Change LINKEDTABLE
I get an error message
Error converting data type DBTYPE_DBDATE to datetime.
when I include the "REQUEST_DATE" in the query, otherwise it returns the result set fine...
Can I CAST the REQUEST_DATE to a string or some other datatype to get around this issue?
any help appreciated, thanks