Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unable to connect to excel through 64bit ODBC connector

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

8 Replies
maksim_senin
Partner - Creator III
Partner - Creator III

Hi Dror,

What is the Office version on the server side? Is it x86 or x64?

Assume that x86 can be an issue.

Best regards,

Maxim

avinashelite

Have you installed the 64bit driver in your system ?? could you please check the same

Not applicable
Author

We have Office 2016 64bit version installed

Not applicable
Author

I assume the driver is automatically installed, no?

this is what we have

Capture.PNG

avinashelite

Your rite if you have installed office by default the driver will be installed ...what s the version of your office 32 bit or 64 bit ?? I think the it might be 32 bit please check the version in the server

Not applicable
Author

64 bit

Capture.PNG

avinashelite

try replacing the CONNECT64 by CONNECT

Not applicable
Author

I did. with no luck