Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Have you installed the 64bit driver in your system ?? could you please check the same
We have Office 2016 64bit version installed
I assume the driver is automatically installed, no?
this is what we have
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
64 bit
try replacing the CONNECT64 by CONNECT
I did. with no luck