Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ryo_okabe
Partner Ambassador
Partner Ambassador

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
Anonymous
Not applicable

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