6 Replies Latest reply: Oct 6, 2016 2:11 AM by Rohit Kumar RSS

    How to connect Qlik Sense serverwith accdb

    Fernando Damas Wenzel

      Hi everyone.

       

      I've been facing some problems when trying to connect Qlik Sense Server with MS Access database (accdb).

       

      When I try to create this connection in Sense Server, the ODBC option gives me nothing as you can see in the image below:

      ODBC.PNG

       

      ... and when I try to connect using OLEDB, choosing the Microsoft Jet option, it doesnt work either. Here, i receive the message that the connection test failed, but no much more details about. I tried choosing diferent kinds of providers, but again with no success.

      OLEDB.PNG

       

      Any thoughts about that? Any help is appreciated.

       

      Many thanks,

      Fernando