Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (1)
8 Replies
maxim_senin
Contributor III

Re: Unable to connect to excel through 64bit ODBC connector

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

Re: Unable to connect to excel through 64bit ODBC connector

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

Not applicable

Re: Unable to connect to excel through 64bit ODBC connector

We have Office 2016 64bit version installed

Not applicable

Re: Unable to connect to excel through 64bit ODBC connector

I assume the driver is automatically installed, no?

this is what we have

Capture.PNG

Re: Unable to connect to excel through 64bit ODBC connector

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

Re: Unable to connect to excel through 64bit ODBC connector

64 bit

Capture.PNG

Highlighted

Re: Unable to connect to excel through 64bit ODBC connector

try replacing the CONNECT64 by CONNECT

Not applicable

Re: Unable to connect to excel through 64bit ODBC connector

I did. with no luck

Community Browser