how to debug a C/C++ native ODBC driver code

[bisenpiyush]

Hi, before jump into the issue I am having, there is little history kinda: I have written an SQLite ODBC Driver by leveraging open source. This code in c/c++ (native). Now, when I try to debug my driver code, with the legacy wizard in Excel, breakpoints always get hit. But whenever I tried to debug my code using power query Excel and Power BI), same code, same driver DLL, (cross-check DLL with the latest code, since breakpoint hit when going with the legacy wizard)  breakpoint never hit. I looked into "Module" window of VS2017/2015. It doesn't show my driver DLL but still, data successfully get fetched. Same issue I am facing with both Excel and Power BI.

I don't understand without loading driver DLL how excel is fetching data. Now, there is some defect I need to resolve, which is only coming if the user tries to fetch data using Power Query( Get data->from ODBC). I guess, I tried enough to find, but now this is last option that I need your help guys.  I am not able to debug my code since breakpoint is not getting hit.

What different happening in case of Power Query.

[v-chuncz-msft]

@bisenpiyush,

You may try to enable tracing by selecting File > Options and settings > Options > Diagnostics.

[bisenpiyush]

Thanks.

I tried by enabling tracing, but not working.

[bisenpiyush]

I have written an SQLite ODBC Driver by leveraging open source. This code in c/c++ (native). Now, when I try to debug my driver code, with Excel using the legacy wizard (to fetch data), breakpoints always get hit. But whenever I tried to debug my code using power query, same code, same driver DLL, (cross-check DLL with the latest code, since breakpoint hit when going with the legacy wizard) breakpoint never hit. I looked into "Module" window of VS2017/2015. It doesn't show my driver DLL but still, data successfully get fetched. Same issue I am facing with Power BI.

I don't understand without loading driver DLL how excel/power Bi is fetching data. Now, there is some defect I need to resolve, which is generating only if the user tries to fetch data using Power Query( Get data->from ODBC). Until I won't able to debug, I can't resolve the defect. I also tried to post the similar question in Excel and Power Bi community but did not get any help.