Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Author

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