topic Re: We cannot convert the value null to type table in Developer

We cannot convert the value null to type table

QIAO — Wed, 24 Jan 2018 04:55:55 GMT

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 run Import mode smoothly.

Re: We cannot convert the value null to type table

v-chuncz-msft — Thu, 25 Jan 2018 05:06:12 GMT

@QIAO,

You may check code in The Advanced Editor.

Re: We cannot convert the value null to type table

QIAO — Thu, 25 Jan 2018 22:56:27 GMT

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.

Re: We cannot convert the value null to type table

QIAO — Fri, 26 Jan 2018 02:40:44 GMT

Solved, it's because SQLExecute should return SQL_SUCCESS instead of return SQL_NO_DATA when load empty table.

Re: We cannot convert the value null to type table

mvarma — Fri, 26 Jan 2018 13:45:01 GMT

We are experiencing the same issue. The table is not empty. Can you please provide a solution on how to resolve this?

Re: We cannot convert the value null to type table

QIAO — Sun, 28 Jan 2018 22:36:15 GMT

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.