Execute query error Unknown SQL type - -99


I have connected to db2 instance through ODBC driver and facing issue in execute query. Even select * from tablename throws below exception whereas it results for the query select count(*) from tablename. Please advise.

Source: Execute Query

Message: Unknown SQL type - -99.

Exception Type: ArgumentException

System.ArgumentException: Unknown SQL type - -99.


Can you try explicitly giving column names in the query instead of ‘*’.

I mentioned the column names and yes it worked. But in one of the column I have xml data in a table and when I specify it, the same issue occurs. Can you please provide solution to it.

The column is of CLOB data type.