I am getting below error while i am loading the data in qlikview.
SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
ODBC CONNECT64 TO [Excel Files;DBQ=X:\ data\Employee data_31st_Dec_2017.xlsx]
Operating system is 32 bit.
Please help to solve the issue.
same error: Resolved below did you check this?
Setup 32 bit ODBC by executing c:\windows\sysWOW64\odbcad32.exe.
In QV ODBC script statement click on "Force 32 bit" and redo the ODBC statement. Click "Connect" button and select the ODBC source. Should be "ODBC CONNECT32 TO" as oposed to "ODBC CONNECT TO".
is this reason?
You need to check the bitness of the actual SQL ODBC Driver on the Server, not the bitness of the computers. I am not sure if you are using and USER or SYSTEM DSN but you could check also to see if that DSN name is showing up on the 64 bit ODBC DataSource Administrator or your 32 bit one. To check the 32 bit one, make sure you don't already have the ODBC Data Source Administrator running in 64 bit, your default, because it will still be showing the 64 bit DSNs.
I don't use USER or System DSN.
Example (OS maybe 32 or 64 QV file was migrate):
IF FileSize('..\EXCELReports\MyFile.xlsx') > 0 Then
A AS Field1,
B AS Field2,
'EUR' AS FLCurrency,
Day(H) AS day_qv_sum,
Month(H) AS month_qv_sum,
Year(H) AS year_qv_sum,
SUM(M) AS sum_FL_Sum
(ooxml, explicit labels, header is 3 lines, table is Sheet1)
Group by H,'EUR';
First i have done: