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

      Hi,

       

      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)];
        tables: 
        SQLtables; 
        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

       

      Dror