8 Replies Latest reply: Apr 20, 2016 6:12 AM by Dror Svartzman RSS

    Unable to connect to excel through 64bit ODBC connector

    Dror Svartzman



      Following an upgrade to OFFICE 2016 and switching over to 64bit version, i'm getting the following error when trying to connect to excel file

      19-4-2016 14:59:56: 0621    ODBC CONNECT64*

      19-4-2016 14:59:56:         Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application


      the error is reaction of the following statement

      For each file in FileList('$(file_src)')
         //Get all sheets names
         ODBC CONNECT64 TO [Excel Files;DBQ=$(file)];
        DISCONNECT; // Don't need ODBC connection anymore


      'Force 32 bit' is checked out


      Here is the weird part. when executing the statement on Qlikview desktop version  (locally on the server) it works fine.

      It only fails on the Pubisher (server side execution)


      Any idea's ? help much appreciated