https://community.qlik.com/t5/Connectivity-Data-Prep/Simple-Query-doesn-t-work-with-Direct-Query/m-p/2091155#M12480 <P>Hi,&nbsp;</P> <P>A query with a simple select that works in regular SQL doesn't in Direct Query. The rror message shown is: <STRONG>ERROR [02000] SQL compilation error: "`DB_NAME`" does not exist or not authorized.</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Error Message" style="width: 390px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/111689i8DB1FFA39440A803/image-size/medium?v=v2&amp;px=400" role="button" title="JulioArriagaDerevo_0-1688653341503.png" alt="Error Message" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Error Message</span></span></P> <P>Query used:<BR />DIRECT QUERY<BR />DIMENSION<BR />JOB_ID<BR />MEASURE<BR />STATUS<BR />FROM "GRAY_DB"."JOBPOSTINGS_2_SCHEMA"."SOC_DECANARIA_RESULTS";</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Full Error Message" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/111693i6982B35113589FCB/image-size/medium?v=v2&amp;px=400" role="button" title="JulioArriagaDerevo_4-1688654104638.png" alt="Full Error Message" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Full Error Message</span></span></P> <P>Success of a simple query:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Simple Query Working" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/111691i314C74B98E9CAC20/image-size/medium?v=v2&amp;px=400" role="button" title="JulioArriagaDerevo_2-1688653860077.png" alt="Simple Query Working" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Simple Query Working</span></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 06 Jul 2023 14:36:57 GMT JulioArriagaDerevo 2023-07-06T14:36:57Z https://community.qlik.com/t5/Connectivity-Data-Prep/Simple-Query-doesn-t-work-with-Direct-Query/m-p/2091155#M12480 <P>Hi,&nbsp;</P> <P>A query with a simple select that works in regular SQL doesn't in Direct Query. The rror message shown is: <STRONG>ERROR [02000] SQL compilation error: "`DB_NAME`" does not exist or not authorized.</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Error Message" style="width: 390px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/111689i8DB1FFA39440A803/image-size/medium?v=v2&amp;px=400" role="button" title="JulioArriagaDerevo_0-1688653341503.png" alt="Error Message" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Error Message</span></span></P> <P>Query used:<BR />DIRECT QUERY<BR />DIMENSION<BR />JOB_ID<BR />MEASURE<BR />STATUS<BR />FROM "GRAY_DB"."JOBPOSTINGS_2_SCHEMA"."SOC_DECANARIA_RESULTS";</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Full Error Message" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/111693i6982B35113589FCB/image-size/medium?v=v2&amp;px=400" role="button" title="JulioArriagaDerevo_4-1688654104638.png" alt="Full Error Message" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Full Error Message</span></span></P> <P>Success of a simple query:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Simple Query Working" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/111691i314C74B98E9CAC20/image-size/medium?v=v2&amp;px=400" role="button" title="JulioArriagaDerevo_2-1688653860077.png" alt="Simple Query Working" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Simple Query Working</span></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 06 Jul 2023 14:36:57 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Simple-Query-doesn-t-work-with-Direct-Query/m-p/2091155#M12480 JulioArriagaDerevo 2023-07-06T14:36:57Z