topic Re: Error in ODBC Connection in QlikView

Error in ODBC Connection

suryakant241187 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

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.

Regards,

Suryakant

Re: Error in ODBC Connection

Chanty4u — Fri, 16 Mar 2018 06:18:28 GMT

Try selecting Force 32 Bit option in Expression Editor below the ODBC list box.

The Great ODBC Confusion

Re: Error in ODBC Connection

suryakant241187 — Fri, 16 Mar 2018 06:22:30 GMT

Hi,

I have already tried Check, Uncheck of 32 Bit option but its not working

Regards,

Suryakant

Re: Error in ODBC Connection

Chanty4u — Fri, 16 Mar 2018 06:23:44 GMT

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".

Re: Error in ODBC Connection

sharuta — Fri, 16 Mar 2018 06:24:24 GMT

You Need to use 32 bit connector:

ODBC CONNECT TO [Excel .....

Another method:

Directory;

LOAD [Field1],

[Field2],

[Field3]

FROM

X:\ data\MyFile.xlsx

(ooxml, embedded labels, table is Sheet1) ;

Re: Error in ODBC Connection

suryakant241187 — Fri, 16 Mar 2018 06:29:09 GMT

Hi,

Getiing Error:

ODBC read Failed.

Re: Error in ODBC Connection

Chanty4u — Fri, 16 Mar 2018 06:32:11 GMT

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.

Re: Error in ODBC Connection

sharuta — Fri, 16 Mar 2018 06:39:36 GMT

Try to create USER DSN in your OS to your File without QlikView. Perhaps problem in OS?

Try duplicate this operation on another Computer.

Re: Error in ODBC Connection

sharuta — Fri, 16 Mar 2018 06:50:04 GMT

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

Directory;

[xMyFile]:

LOAD

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

FROM

[..\EXCELReports\MyFile.xlsx]

(ooxml, explicit labels, header is 3 lines, table is Sheet1)

WHERE(IsNum(M))

Group by H,'EUR';

ENDIF

Re: Error in ODBC Connection

suryakant241187 — Fri, 16 Mar 2018 07:40:15 GMT

First i have done:

The 64-bit drivers are configured using C:\Windows\System32\odbcad32.exe
(Can be started from the ControlPanel ˃ Adminstrative Tools > Data Sources (ODBC).)
and then Tried selecting Force 32 Bit option its worked for me.

Thanks

Re: Error in ODBC Connection

Chanty4u — Fri, 16 Mar 2018 07:41:45 GMT

great have a nice day

best

Chanty