Select Statement does not work in SQL Select (scipt)

[MohasinKhan]

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.

[tresesco]

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]

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]

Try using '*' instead of mentioning field names.

[florentina_doga]

use

sql select * from ....

[MohasinKhan]

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]

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.