Forum Discussion
QIAO
8 years agoHelper II
We cannot convert the value null to type table
I try to use Direct Query mode to load data, but always get "we cannot convert the value null to type table" in the "Create connections" stage. Found not error in ODBC trace log. WHY?? I can ru...
- 8 years ago
Solved, it's because SQLExecute should return SQL_SUCCESS instead of return SQL_NO_DATA when load empty table.
v-chuncz-msft
8 years agoCommunity Support
QIAO
8 years agoHelper II
I tested. When i comes to use Query Editor, it runs okay. But get data through Home->Get data, it would throw error like this.
- QIAO8 years agoHelper II
Solved, it's because SQLExecute should return SQL_SUCCESS instead of return SQL_NO_DATA when load empty table.
- mvarma8 years agoRegular Visitor
We are experiencing the same issue. The table is not empty. Can you please provide a solution on how to resolve this?
- QIAO8 years agoHelper II
As I said, SQLExecute/SQLExecDirectW returned SQL_NO_DATA when loading empty table, it should return SQL_SUCCCESS. That's the way I solved my problem.