Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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