7 Replies Latest reply: Dec 1, 2016 7:24 AM by Ilya Komlyakov RSS

    CONNECTs other than LIB CONNECT are not available in this script mode

      Hi,

       

      I am trying to dynamically load ODBC Connection string through xml file (custom config file ) in  Qlik Sense Desktop 1.1  as below:

       

      LET vFolderPath = 'lib://ReportsFilePath/';

      LOAD key, value
      FROM $(vFolderPath)AppConfig.xml (XmlSimple, Table is [qsConfiguration/qsElement])
      WHERE key = 'ConnString';

       

      LET vConnString = peek('value');

       

      ODBC Connect to $(vConnString);

       

      However, I receive following error on last line as:

       

      CONNECTs other than LIB CONNECT are not available in this script mode.

       

      Can you please help?

       

      Thanks,

       

      Greeshma