Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

marcosadlercreutz
New Contributor II

SQL Query works in SQL Management Studio but not in QlikSense

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

 

1 Solution

Accepted Solutions
dwforest
Valued Contributor

Re: SQL Query works in SQL Management Studio but not in QlikSense

You cannot CREATE tables or INSERT rows from Qlik Sense

The "similar" thread only contains SELECTs

4 Replies
Highlighted
dwforest
Valued Contributor

Re: SQL Query works in SQL Management Studio but not in QlikSense

Qlik is designed for SELECT statements only

marcosadlercreutz
New Contributor II

Re: SQL Query works in SQL Management Studio but not in QlikSense

@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!

MVP & Luminary
MVP & Luminary

Re: SQL Query works in SQL Management Studio but not in QlikSense

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
Valued Contributor

Re: SQL Query works in SQL Management Studio but not in QlikSense

You cannot CREATE tables or INSERT rows from Qlik Sense

The "similar" thread only contains SELECTs