Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted
Specialist II
Specialist II

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

View solution in original post

4 Replies
Highlighted
Specialist II
Specialist II

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

Qlik is designed for SELECT statements only

Highlighted
Contributor II
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!

Highlighted
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

Highlighted
Specialist II
Specialist II

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

View solution in original post