9 Replies Latest reply: May 18, 2017 5:47 AM by Iftikhar Ali RSS

    OLE DB (Work group info file is missing ) and ODBC  (Not a valid password)

    Iftikhar Ali

      HI

      I want to conncect MS access 2007  database (.mdb ) format to Qlikview.

       

      OLEDB

      Step  1 :  Install AccessDatabaseEngine and AccessRuntime_x64_en-us

      Step 2  :  Now open Script editor in Qlikview

      Step 3 :  From Database  i select   "OLEDB"   tick mark    "Force 32 Bit" and click "Connect"

      Step 4 : Now select "Microsoft jet 4.0 OLE DB Provider"   and move to Connection tab.

      Step  5 :   Now i enter database name password

                          (1)  Path of database

                     (2) User name and password      

      and click "Test Connection "  and get the following error


      "Test connection failed becaues of an error in initializing  provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user".


      ODBC

      Step  1 :  Install AccessDatabaseEngine and AccessRuntime_x64_en-us

      Step  2:  Create odbc conncection to my database  from script editor

                    Connection String

      ODBC CONNECT TO [MQTU;DBQ=Path\Database.mdb] (XUserId is JCTafQRMNLacWNC, XPassword is aRSBXRdNSLZEDSVOPbFB);

      Step  3 : Now i load all the required tables from my database

      Step  4: Now Click Reload button to load data form database and it give me an  error

       

      SQL##f - SqlState: 42000, ErrorCode: 4294965391, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password.

       

      if my password is wrong then how it load my tables