https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-products-Generate-an-ODBC-Trace-with-ODBC/ta-p/2086670 <P><SPAN>Troubleshooting connections to data sources may require tracing data traffic to reveal the communication patterns and details between a client and the database server.</SPAN></P> <P><SPAN>We advise to first&nbsp;narrow down the issue as much as possible.&nbsp;If the load script of the .qvw / .qvf contains a lot of statements it helps a lot if a smaller document can be created, one which contains only the problem statements.<BR /><BR />For steps on enabling ODBC Tracing, see the following:</SPAN></P> <P class="lia-indent-padding-left-30px"><A href="https://docs.microsoft.com/en-us/sql/odbc/admin/setting-tracing-options?view=sql-server-2017" target="_blank" rel="noopener">Setting Tracing Options</A><BR /><A href="https://docs.oracle.com/cd/E17952_01/connector-odbc-en/connector-odbc-configuration-trace-windows.html" target="_blank" rel="noopener">Enabling ODBC Tracing on Windows</A></P> <P>In addition, enable QVConnect logging:</P> <P class="lia-indent-padding-left-30px"><A href="https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-products-QVConnect-logging/ta-p/2086675" target="_blank" rel="noopener">Troubleshooting Qlik products: QVConnect logging</A>&nbsp;</P> <P>&nbsp;</P> <P style="font-style: italic;">&nbsp;</P> <H3 id="toc-hId-1947996985"><STRONG><FONT color="#339966">Related Content</FONT></STRONG>&nbsp;</H3> <P class="lia-indent-padding-left-30px"><A href="https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Data-Connections-in-Qlik-Cloud-and-Qlik-Sense/ta-p/2074907" target="_blank" rel="noopener">Troubleshooting Data Connections in Qlik Cloud and Qlik Sense Enterprise on Windows</A><BR /><A href="https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-products-QVConnect-logging/ta-p/2086675" target="_blank" rel="noopener">Troubleshooting Qlik products: QVConnect logging</A>&nbsp;<BR /><A href="https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-products-How-to-generate-OLEDB-tracing/ta-p/2086669" target="_blank" rel="noopener">Troubleshooting Qlik products: How to generate OLEDB tracing</A>&nbsp;</P> <P class="lia-indent-padding-left-30px">&nbsp;</P> <P><EM>The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.</EM></P> Thu, 22 Jun 2023 09:12:04 GMT Sonja_Bauernfeind 2023-06-22T09:12:04Z https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-products-Generate-an-ODBC-Trace-with-ODBC/ta-p/2086670 <P><SPAN>Troubleshooting connections to data sources may require tracing data traffic to reveal the communication patterns and details between a client and the database server.</SPAN></P> <P><SPAN>We advise to first&nbsp;narrow down the issue as much as possible.&nbsp;If the load script of the .qvw / .qvf contains a lot of statements it helps a lot if a smaller document can be created, one which contains only the problem statements.<BR /><BR />For steps on enabling ODBC Tracing, see the following:</SPAN></P> <P class="lia-indent-padding-left-30px"><A href="https://docs.microsoft.com/en-us/sql/odbc/admin/setting-tracing-options?view=sql-server-2017" target="_blank" rel="noopener">Setting Tracing Options</A><BR /><A href="https://docs.oracle.com/cd/E17952_01/connector-odbc-en/connector-odbc-configuration-trace-windows.html" target="_blank" rel="noopener">Enabling ODBC Tracing on Windows</A></P> <P>In addition, enable QVConnect logging:</P> <P class="lia-indent-padding-left-30px"><A href="https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-products-QVConnect-logging/ta-p/2086675" target="_blank" rel="noopener">Troubleshooting Qlik products: QVConnect logging</A>&nbsp;</P> <P>&nbsp;</P> <P style="font-style: italic;">&nbsp;</P> <H3 id="toc-hId-1947996985"><STRONG><FONT color="#339966">Related Content</FONT></STRONG>&nbsp;</H3> <P class="lia-indent-padding-left-30px"><A href="https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Data-Connections-in-Qlik-Cloud-and-Qlik-Sense/ta-p/2074907" target="_blank" rel="noopener">Troubleshooting Data Connections in Qlik Cloud and Qlik Sense Enterprise on Windows</A><BR /><A href="https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-products-QVConnect-logging/ta-p/2086675" target="_blank" rel="noopener">Troubleshooting Qlik products: QVConnect logging</A>&nbsp;<BR /><A href="https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-products-How-to-generate-OLEDB-tracing/ta-p/2086669" target="_blank" rel="noopener">Troubleshooting Qlik products: How to generate OLEDB tracing</A>&nbsp;</P> <P class="lia-indent-padding-left-30px">&nbsp;</P> <P><EM>The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.</EM></P> Thu, 22 Jun 2023 09:12:04 GMT https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-products-Generate-an-ODBC-Trace-with-ODBC/ta-p/2086670 Sonja_Bauernfeind 2023-06-22T09:12:04Z