4 Replies Latest reply: Feb 28, 2017 4:35 AM by Sankar Rajamoorthy RSS

    Error creating User Directory Qlik Sense via Excel

    Paul Damen

      Hi,

       

      I am trying to set up an User Directory Connection in Sense via the Excel ODBC. But I keep getting the message: "Exception when trying to connect to the data source, Edit the connection string in the User directory connector configuration"

       

      I have set up a Excel ODBC 32 bit on the server Sense is run on. In the visible connection string I have:

       

      DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\ExcelODBCUDC.xls. The ExcelODBCUDC.xls leads to the excel.

       

      What am I doing wrong here? Am I forgetting something?

       

      Regards, Paul