1 Reply Latest reply: Jun 1, 2016 6:56 AM by Chandrasheker Gompa RSS

    The difference of the connection method of QlikView and Qlik Sense

    Ryo Okabe

      Hi all,

       

      I am trying to connect to the Marketo in the ODBC driver.

       

      I was able to use without a problem when I tried in QlikView.

      However, Qlik Sense did not work properly.

       

      I installed QlikView and Qlik Sense in the same environment.

      And both have been using the same ODBC driver.

       

      Following is log.

       

      ----------------------------------------------------------------------

      <<<<<<<QlikView>>>>>>

      2016-05-31 17:09:56 0020 *CONNECT*

      2016-05-31 17:10:08 0022 LOAD ActivityId,

      2016-05-31 17:10:08 0023     LeadId,

      2016-05-31 17:10:08 0024

      2016-05-31 17:10:08 0025     ListId

      2016-05-31 17:10:08 0026

      2016-05-31 17:10:08 0027

      2016-05-31 17:10:08 0028    

      2016-05-31 17:10:08 0029 SQL SELECT *

      2016-05-31 17:10:08 0030 FROM CData."Activities_AddToList"

      2016-05-31 17:10:14          3 fields found: ActivityId, LeadId, ListId,

      2016-05-31 17:10:14      25 lines fetched

      2016-05-31 17:10:14      Execution finished.

       

       

      <<<<<<Qlik Sense>>>>>

      2016-05-31 17:05:28 0020 *CONNECT*

      2016-05-31 17:05:40 0022 LOAD ActivityId,

      2016-05-31 17:05:40 0023     LeadId,

      2016-05-31 17:05:40 0024

      2016-05-31 17:05:40 0025     ListId

      2016-05-31 17:05:40 0026

      2016-05-31 17:05:40 0027

      2016-05-31 17:05:40 0028    

      2016-05-31 17:05:40 0029 SQL SELECT *

      2016-05-31 17:05:40 0030 FROM CData."Activities_AddToList"

      2016-05-31 17:05:40      Error: SQL##f - SqlState: 08003, ErrorCode: 4294967295, ErrorMsg: Connection does not exist

      2016-05-31 17:05:40      SQL##f - SqlState: 08003, ErrorCode: 4294967295, ErrorMsg: Connection does not exist

      2016-05-31 17:05:40      Execution Failed

      2016-05-31 17:05:40      Execution finished.

      ----------------------------------------------------------------------

       

      I think that connection method of QlikView and Qlik Sense are different.

       

      Does anyone know what might be causing this?

        • Re: The difference of the connection method of QlikView and Qlik Sense
          Chandrasheker Gompa

          Hi,

           

          Please see the syntax below and also ensure you establish the connection to the server properly:

          you have to insert the string before loading the app and it will look like below:

           

          LIB CONNECT TO 'S--LONBUS-FINANCE-Fin Systems-Finance Transformation-3 - MI Reporting-Phase 3-Expenses - Dashboard-New Expenses Database 2007 Version - To Account Level.accdb';

           

           

          Actual:

          LOAD AccGroup1,

              AccGroup2,

              AccGroup3,

              AccGroup4,

              AccGroup5,

              AccGroup6,

              `Year`;

          SQL SELECT AccGroup1,

              AccGroup2,

              AccGroup3,

              AccGroup4,

              AccGroup5,

              AccGroup6,

              `Year`

          FROM `Qry Everything YTD`

           

          Thanks