topic Continuous SQLMoreResults without fetching any data in Developer

topic Continuous SQLMoreResults without fetching any data in Developer https://community.fabric.microsoft.com/t5/Developer/Continuous-SQLMoreResults-without-fetching-any-data/m-p/296716#M8736 <P>I am writing a ODBC driver for Athena. When I try to fetch data by Power BI through ODBC driver, I get lots of continuous <SPAN>SQLMoreResults without fetching any data. I attached some loggers, and don't understand why POWER BI call SQLMoreResults  so frequently without fetching any data??</SPAN></P><P> </P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 100 (SQL_NO_DATA_FOUND)<BR />HSTMT 0x00000270A09B3670</P> Mon, 06 Nov 2017 02:45:38 GMT QIAO 2017-11-06T02:45:38Z Continuous SQLMoreResults without fetching any data https://community.fabric.microsoft.com/t5/Developer/Continuous-SQLMoreResults-without-fetching-any-data/m-p/296716#M8736 <P>I am writing a ODBC driver for Athena. When I try to fetch data by Power BI through ODBC driver, I get lots of continuous <SPAN>SQLMoreResults without fetching any data. I attached some loggers, and don't understand why POWER BI call SQLMoreResults  so frequently without fetching any data??</SPAN></P><P> </P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 0 (SQL_SUCCESS)<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 ENTER SQLMoreResults<BR />HSTMT 0x00000270A09B3670</P><P>Microsoft.Mashu 41a0-2fd4 EXIT SQLMoreResults with return code 100 (SQL_NO_DATA_FOUND)<BR />HSTMT 0x00000270A09B3670</P> Mon, 06 Nov 2017 02:45:38 GMT https://community.fabric.microsoft.com/t5/Developer/Continuous-SQLMoreResults-without-fetching-any-data/m-p/296716#M8736 QIAO 2017-11-06T02:45:38Z Re: Continuous SQLMoreResults without fetching any data https://community.fabric.microsoft.com/t5/Developer/Continuous-SQLMoreResults-without-fetching-any-data/m-p/314329#M9295 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/46164">@QIAO</a>,</P> <P> </P> <P>Make sure the SQL statement only returns one result set.</P> Thu, 30 Nov 2017 05:38:48 GMT https://community.fabric.microsoft.com/t5/Developer/Continuous-SQLMoreResults-without-fetching-any-data/m-p/314329#M9295 v-chuncz-msft 2017-11-30T05:38:48Z