Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ryookabe
New Contributor

The difference of the connection method of QlikView and Qlik Sense

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?

1 Reply
gompa786
Contributor III

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

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