Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bimala0507
Contributor

Not able connect to Oracle db installed in my local m/c

Hi All:

I am trying to connect to  Oracle db installed in my m/c through ODBC connection to generate a qvd file. It throws an architecture mismatch error and hence not able to connect  to the database. Could some expert throw some light on this. attached the error file.

Thanks & Regards,

Bimala

4 Replies
Sokkorn
Honored Contributor

Re: Not able connect to Oracle db installed in my local m/c

Hi Bimala,

You are run on x64. ODBC should be create under C:\Windows\SysWOW64

Untitled.png

Can you check and confirm?

Regards,

Sokkorn

bimala0507
Contributor

Re: Not able connect to Oracle db installed in my local m/c

Hi Sokkorn:

Thx much.Screenshot ODBC.png

Yes it is under the same directory. Attached the screenshot.

Kind Regards,

Bimala

Sokkorn
Honored Contributor

Re: Not able connect to Oracle db installed in my local m/c

Hi Bimala,

Does it work or not when we test under SysWOW64?

Regards,

Sokkorn

bimala0507
Contributor

Re: Not able connect to Oracle db installed in my local m/c

Hi Sokkorn:

There is the catch, when I run from SYSWOW64, it throws me the same Architecture mismatch error and asking me to reinstall the ODBC driver. However through Control Panel, it works fine.

Kind Regards,

Bimala

Community Browser