https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-cannot-load-the-dbo-from-SQL/m-p/1699690#M5127 <P>Hello all,</P><P>Recently, I have met an issue about SQL connection in Qlik Sense.</P><P>I want to connect the SQL Server through OLE DB. The connection is tested successfully.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kwoklimho_1-1588835286910.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33097i67F560B744CC9792/image-size/medium?v=v2&amp;px=400" role="button" title="kwoklimho_1-1588835286910.jpeg" alt="kwoklimho_1-1588835286910.jpeg" /></span></P><P>Also, the database contains the dbo.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kwoklimho_2-1588835378976.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33098i5994F157B0ADEB43/image-size/medium?v=v2&amp;px=400" role="button" title="kwoklimho_2-1588835378976.jpeg" alt="kwoklimho_2-1588835378976.jpeg" /></span></P><P>In normal case, I can find the table(dbo) by clicking the database and owner.</P><P>But now, I can't find any table from the Owner, can anybody help?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kwoklimho_4-1588835542019.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33100i9C7D10AAA75763E2/image-size/medium?v=v2&amp;px=400" role="button" title="kwoklimho_4-1588835542019.jpeg" alt="kwoklimho_4-1588835542019.jpeg" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kwoklimho_5-1588835547137.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33101iB0863D31BA517133/image-size/medium?v=v2&amp;px=400" role="button" title="kwoklimho_5-1588835547137.jpeg" alt="kwoklimho_5-1588835547137.jpeg" /></span></P><P>SQL Version:&nbsp;sql server 2017 express</P><P>Qlik Sense Version:&nbsp;qlik sense sep 2019</P><P>Regards,</P><P>Leo</P> Thu, 07 May 2020 07:18:13 GMT kwoklimho 2020-05-07T07:18:13Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-cannot-load-the-dbo-from-SQL/m-p/1699690#M5127 <P>Hello all,</P><P>Recently, I have met an issue about SQL connection in Qlik Sense.</P><P>I want to connect the SQL Server through OLE DB. The connection is tested successfully.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kwoklimho_1-1588835286910.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33097i67F560B744CC9792/image-size/medium?v=v2&amp;px=400" role="button" title="kwoklimho_1-1588835286910.jpeg" alt="kwoklimho_1-1588835286910.jpeg" /></span></P><P>Also, the database contains the dbo.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kwoklimho_2-1588835378976.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33098i5994F157B0ADEB43/image-size/medium?v=v2&amp;px=400" role="button" title="kwoklimho_2-1588835378976.jpeg" alt="kwoklimho_2-1588835378976.jpeg" /></span></P><P>In normal case, I can find the table(dbo) by clicking the database and owner.</P><P>But now, I can't find any table from the Owner, can anybody help?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kwoklimho_4-1588835542019.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33100i9C7D10AAA75763E2/image-size/medium?v=v2&amp;px=400" role="button" title="kwoklimho_4-1588835542019.jpeg" alt="kwoklimho_4-1588835542019.jpeg" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kwoklimho_5-1588835547137.jpeg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33101iB0863D31BA517133/image-size/medium?v=v2&amp;px=400" role="button" title="kwoklimho_5-1588835547137.jpeg" alt="kwoklimho_5-1588835547137.jpeg" /></span></P><P>SQL Version:&nbsp;sql server 2017 express</P><P>Qlik Sense Version:&nbsp;qlik sense sep 2019</P><P>Regards,</P><P>Leo</P> Thu, 07 May 2020 07:18:13 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-cannot-load-the-dbo-from-SQL/m-p/1699690#M5127 kwoklimho 2020-05-07T07:18:13Z