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

    Error creating User Directory Qlik Sense via Excel

    Paul Damen



      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