Forum Discussion
OLE DB or ODBC error: type mismatch (exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))
Hello, I have a report that has been running just fine for the last few weeks. Nothing has changed about the report. Upon attempting to refresh the data today - it does not work. If gives m...
It worked thank you very much!
Too bad I had to copy all my old measures again and change the origin of the dependant queries, but it helped a lot :)
A date field was giving me probs, it loaded from SQL as text, so I changed it to Decimal number and then then tried to create a Date field, But I still got that message, so I left it as a Decimal number and created four seperate columns, Year, Month, Day and then concateated them together and the query reloads without the error. Hope that helps someone.