topic Re: Dont select data from sql dbo tables.. in Connectivity & Data Prep

Dont select data from sql dbo tables..

Liudas — Wed, 24 Aug 2022 10:44:35 GMT

In Qlik Cloud version we can't connect to sql (.dbo) database. We have successfully connected to the server. we can extract data from sys or information schema tables, but not from dbo table. Error: „Error connecting to the Sense service“. In desktop version works and microsoft sql managament studio works perfectly. Does anyone have any ideas?

Re: Dont select data from sql dbo tables..

NadiaB — Wed, 24 Aug 2022 13:33:24 GMT

Hi @Liudas

That error looks misleading, if you are able to connect to the DB and read from sys tables, the only think that occurs to me is that the user is not able to read from that table, are you using the same user when testing in the different tools mentioned above?

Since you are trying to use "from dbo.tablename "to trigger the query, if you try with "from databasename.dbo.tablename", does it work ? Other think would be to use the preview and let Qlik Sense generate the query (from the connection select "select data" and use the tool to autogenerate the query).

Let us know the outcome of the test mentioned above.

Re: Dont select data from sql dbo tables..

Liudas — Thu, 25 Aug 2022 05:05:11 GMT

Hi Nadia

I use the same user when im testing.

When i manually write the login script and program code:

LIB CONNECT TO 'Connection name';

SQL SELECT

...

FROM databasename.dbo.tablename;

It works perfectly.

But in preview mode im getting an error:

Why Qlik Sense cant generate query automatically?

Thank you for you help.

Re: Dont select data from sql dbo tables..

NadiaB — Thu, 25 Aug 2022 13:24:33 GMT

Hi @Liudas

That information is very helpful, so basically you can query dbo tables directly in the script but not select anything from the preview window.

Do you see any errors in the Network tab browser tools ?

Sometimes that information has more details than the error presented in the window.

Save network web traffic (HAR/XML file) and console logs from the browser's developer tools

https://community.qlik.com/t5/Knowledge/Save-network-web-traffic-HAR-XML-file-and-console-logs-from-the/ta-p/1714049

Kind Regards.

Re: Dont select data from sql dbo tables..

Liudas — Fri, 26 Aug 2022 10:48:55 GMT

Hi NadiaB,

Thank for you help.

Can you explain where the problem might be?