Forum Discussion
OLE DB or ODBC error DISP_E_TYPEMISMATCH
The type mismatch is probably happening because you're doing some conversion from the orginial data types - go into the query editor and remove any type conversions and see if that works.
Unfortunatly I am now getting this error on a dataset that had been working fine for months. I dont even have any change type commands in my query. The only reason I knew there was an error is because my on premises gateway data suddenly stopped refreshing today and no ones dashboards worked.
Any other ideas on how to troubleshoot?
Thnk you,
Jesse
Never mind! One of our sales reps accidentally typed "Trina" into the sales order number field and hit "save"... sigh. All good now.
Thanks for posting with your findings. I used your answer to solve my problem. Someone also typed a word into a date field being funny, using "eternity" as their target resolution date. Now I know the first thing to look for!