I have created a LINKED Server to an IBM AS400 system and am using an OPENQUERY to return a dataset from the AS400. This dataset is subsquently joined to a SQLServer table. The query is sending the follwing error message back that is date related, can anyone help????
Server: Msg 7332, Level 16, State 2, Line 3 Could not rescan the result set from OLE DB provider 'IBMDA400'. The table was built over a live data stream and the position cannot be restarted. OLE DB error trace [OLE/DB Provider 'IBMDA400' IRowset::RestartPosition returned 0x80040e18].