OLE DB or ODBC error DISP_E_TYPEMISMATCH

[adrien5555]

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

[adrien5555]

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]

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]

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!