2 Replies Latest reply: Apr 6, 2017 4:09 AM by rohit gupta RSS

    QlikView 11.2 SR8 Direct Discovery error on AccessPoint

    Dimitri Obrant


      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.