Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
marcosadlercreutz
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
dwforest
Specialist II
Specialist II

You cannot CREATE tables or INSERT rows from Qlik Sense

The "similar" thread only contains SELECTs

View solution in original post

4 Replies
dwforest
Specialist II
Specialist II

Qlik is designed for SELECT statements only

marcosadlercreutz
Contributor II
Contributor II
Author

@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
MVP & Luminary
MVP & Luminary

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
Specialist II
Specialist II

You cannot CREATE tables or INSERT rows from Qlik Sense

The "similar" thread only contains SELECTs

View solution in original post