SQL Query works in SQL Management Studio but not in QlikSense

[marcosadlercreutz]

Hi Guys!

I have a SQL Server Query that works fine in SQL Management Studio. It returns a table with data.

When i use the same query in Qlik Sense it returns an error: "Connector reply error: ErrorSource: Unknown source, ErrorMsg:Unknown description".

I´m using Microsoft OLE DB Provider for SQL Server.

Attached are both codes

Please help!! Thanks in advance!

Marcos

[dwforest]

Qlik is designed for SELECT statements only

[marcosadlercreutz]

@dwforest Thanks for your reply

I think there should be some way to send this query...

f eg: https://community.qlik.com/t5/New-to-QlikView/SQL-Temp-tables/td-p/1012433

In that threat they use a similar query but with a different organization and it seams to work for them...

Some other ideas?

Thanks!

[marcus_sommer]

Qlik doesn't execute any sql-code else it just transferred the statement per driver to the database and waits then to get a return. If you now get an error it's caused from an unsuitable driver and/or a wrong connection and/or missing user/access-rights to the database/network or something similar.

I think I would start with something simple, like:

sql select KnownField from KnownTable;

to ensure that the access in general worked - and if it worked you could go further eliminating step by step all other possible causes.

- Marcus

[dwforest · Accepted solution]

You cannot CREATE tables or INSERT rows from Qlik Sense

The "similar" thread only contains SELECTs