Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dimitri_obrant
Creator
Creator

QlikView 11.2 SR8 Direct Discovery error on AccessPoint


Hello,

I try to develope my first QV App with direct discovery. For access to MS SQL I use OLEDB connectionstring.

In QlikView Desktop works direct discovery fine. But on AccessPoint I get an error "direct query failed".

I cannot find why. AccessPoint and QV Desktop are on the same server.

SCRIPT:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;...;
STAFF:
LOAD
    N
ame,
    ID
;
SQL SELECT *
FROM dbo."V_STAFF";

DIRECT_DISCOVERY:
DIRECT QUERY
     DIMENSION
     ID
     MEASURE
     AMOUNT
     DETAIL
      DATE
FROM dbo."V_TEST";

Any ideas?

Thanks.

2 Replies
Not applicable

I ran into a similar problem. My issue was related to not having the Qlik web service added to the security of the SQL database. Once I added this on, I was able to use Direct Discovery (but still had issues with the Section Access part of things).

rohit214
Creator III
Creator III

Hi Dimitri,

Please just remove the table name from direct query.

Just write

DIRECT QUERY
     DIMENSION
     ID
     MEASURE
     AMOUNT
     DETAIL
      DATE
FROM dbo."V_TEST";

Regards,

Rohit Gupta