Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MohasinKhan
Contributor III
Contributor III

Select Statement does not work in SQL Select (scipt)

Hello,

I am trying to import data from a SQL server using OLE DB, as the access is shared in form of datacube.

Managed to reach the point where i have successfully created a connection, but when I try to import data in script Editor, query fails. I looked up a lot of videos and realized in SQL SELECT part, the "SELECT" is not showing in blue, like part of the statement. I am attaching screenshot of the basic script.

If anyone has any leads, i would really appreciate.

I am using Qliksense Desktop June 2019 release.

PS: I also have access to Enterprise edition of Qliksense, it does not even allow me to see the database. But that is a different topic.

Labels (3)
6 Replies
tresesco
MVP
MVP

It seems that you are not being able to reach the DB from the system where you are running this code from. Test the reachability from the same system
MohasinKhan
Contributor III
Contributor III
Author

hi Tresesco,

Tried it, still does not work. I am able to download data in excel using power query.

It only denies to pull data from Qliksense. 😞 attaching screenshot with issue.

tresesco
MVP
MVP

Try using '*' instead of mentioning field names.

florentina_doga
Partner
Partner

use

sql select * from ....

MohasinKhan
Contributor III
Contributor III
Author

Hello. Thank you for response.

I tried using '*', it connects to the database, but fails to import data. Getting the same error message.

I still notice that "Select" in "SQL Select" statement does not call out as a function.

dwforest
Specialist II
Specialist II

Using the correct 32-bit vs 64-bit driver? I think desktop might be 32.

A simple test is to browse tables via the connection to see if it is configured correctly.

MIght want to switch to newest SQL driver as MS has deprecated the OLE DB one.