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)...
Need Help
  • 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.

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

amitchandak The table the is causing this issue has less than 100 rows with no errors in the date columns. I only use the deleted_at column to filter out items that have been soft deleted. These videos do not cover the OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)) error