2 Replies Latest reply: Jul 19, 2018 7:41 AM by Frido Affourtit RSS

    Relative path  ODBC in QlikSense

    Frido Affourtit

      Hi all,


      Am trying to convert existing dashboards from qlikview to qliksense.


      In the script in Qlikview i'm using the following  (sample) code:


      // set variable path based on variables
      SET v2Path = $(v2Server)$(v2Vestiging)\$(v2Locatie)\$(v2KlantNummer)\$(v2Jaar);


      // connect to database, patch based on variables

      OLEDB CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=False;Data Source=Administratie_Links;Extended Properties="DSN=Administratie_Links;UID=;SourceDB=$(v2Path);SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;"];


      This works great


      But.... in Qliksense i don't get it working. Adding a new connection let me make the following scriptcode, but i can't set the path (sourceDB) anywhere?


      //In Qliksense for connecting the ODBC server / file

      LIB CONNECT TO 'Administratie_Links';

      Anyone how to fix this? I found different solution for Qlikview on solving this problem, but none for Qliksense?

      Thanks in advance!