Forum Discussion

adrien5555's avatar
adrien5555
Helper II
10 years ago
Solved

OLE DB or ODBC error DISP_E_TYPEMISMATCH

Hi All,   this error shows up when I try to refresh data.   The data source is a local csv :     Config: windows 10   thanks for helping :) Adrien  
Need Help
  • austinsense's avatar
    austinsense
    10 years ago

    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.

jessewysong's avatar
jessewysong
Helper III
9 years ago

Never mind! One of our sales reps accidentally typed "Trina" into the sales order number field and hit "save"... sigh. All good now. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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!