Forum Discussion

Kurtle's avatar
Kurtle
Icon for Helper II rankHelper II
6 years ago
Solved

OLE DB or ODBC error: Type mismatch - With no transformations done to Datatype

Hi everyone,     I am receiving this error when trying to add a couple of new columns to my dataset: OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)...
  • Kurtle's avatar
    Kurtle
    6 years ago

    Yes, this problem was solved after a week and a half of back and forth with support. There were 2 cell values that were causing this issue. Instead of 2020 the cell had 2020 (10). Not sure why the quary wasn't returned with errors instead of cancelling the entire refresh but they are looking into it some more.