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.

austinsense's avatar
austinsense
Impactful Individual
10 years ago

Can you just delete the "changed type" step

adrien5555's avatar
adrien5555
Helper II
10 years ago

Sorry, didn't mention that deleting only "changed type" wasn't enough.

 

I had to delete all steps to get the connection with the data back.

 

Anyway, I'll recreate the steps, but It's a bit of a pain if it happens again after many changes in the query editor. We'll see :)

 

Thanks!

  • evang550's avatar
    evang550
    Microsoft Employee
    10 years ago

    Hi adrien - did you ever figure out why this was happening? And if there was a fix/work around? I'm having the same issue.

    • adrien5555's avatar
      adrien5555
      Helper II
      10 years ago

      Hi Evan,

       

      Yes it worked for me. I had to remove all the applied steps (5 or 6) until the step 'changed type' which seemed to cause the error.

       

      Since I re-created all the steps, the error never showed up again, so worth trying it!