Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I tried to use the Direct Discovery Method under QlikView 11.2 with the following syntax:
ODBC CONNECT32 TO [MS Access Database;DBQ=\\ksafsp01\KSAGDAT\IT\01_Alle\001_Projekte\610_SmartScanning\Abgespeicherte_Dokumente.accdb];
Direct QUERY
DIMENSION
Lieferscheinnummer
MEASURE
Datum
FROM tblUnterschriebene_Speditionsaufträge;
I looked through several forum-entries and tried it with different databases without success.
Qlikview somehow does not recognise the Syntax because "DIRECT" becomes blue but "QUERY" not.
I am using QlikView Private edition version 11.2. Is this the problem? Furthermore, when opening a qlikview file, I have a choice between two qlikview versions:
Both versions do not succeed with the direct query syntax.
I think the DIRECT QUERY syntax was introduced in a version later than 11.20 IR, AFAIR, DIRECT SELECT was used before that. There were also other syntax changes at that time.
To make it short, I would recommend to use a recent version of QV (11.20 IR is years old, and I don't want to talk about 11.00 SR1...)