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.

apralou's avatar
apralou
Advocate II
3 years ago

Thanks, this lead me to solve this problem with a file that had been working fine for months.

  1. Take a copy of steps in advanced editor for problem table.
  2. Clear all steps except source. 
  3. Apply and let model complete data refresh without error.
  4. Paste all steps in advanced errror to reinstate table.
  5. Apply and model should complete data refresh without error.

Hugely frustrating and weird fix demonstrating that nothing was actually wrong with the file in the first place but something had changed in the environment.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

This just really helped me resolve my issue. Thanks!