I'm having the same problem with dates and the error, "Conversion failed because the data value overflowed the data type used by the provide".
I think it has to be in the OLE Provider since I am simply trying to query the linked server when I get this error. The problem seems limited to dates.