topic Re: Help me to resolve below error? in QlikView

Help me to resolve below error?

durgabhavani — Thu, 06 Aug 2015 13:55:32 GMT

Hi All,

I have installed oracle in my system. But when i connect to oracle i am getting above error. Can anyone help me to resolve above error.

Thanks,

Durga

Gysbert_Wassenaar — Thu, 06 Aug 2015 13:57:15 GMT

Make sure you installed the right version and you're not trying to use a 32-bit version driver from a 64-bit application.

Clever_Anjos — Thu, 06 Aug 2015 13:57:26 GMT

Can you "tnsping" your server?

It seems to be a client driver issue

Thu, 06 Aug 2015 14:00:45 GMT

Try to connect to Oracle DB through db tool like TOAD, SQL Developer etc then try to generate the db connection.

sasiparupudi1 — Thu, 06 Aug 2015 14:02:00 GMT

its a mismatch between the bits in the client and QV or vice versa

durgabhavani — Fri, 07 Aug 2015 12:36:42 GMT

thanks for responses! How to find the oracle bit version from windows machine.

qlikmsg4u — Fri, 07 Aug 2015 12:38:42 GMT

try this

select * from v$version

sasiparupudi1 — Fri, 07 Aug 2015 12:42:49 GMT

In the odbc manager application, when you click add, see the dll version if it says SQLORA32.dll then it is 32 bit

HTH

Sasi

sasiparupudi1 — Fri, 07 Aug 2015 12:51:16 GMT

or alternatively you could read the documentation from the install folder

file:///C:/Oracle/product/10.1.0/Client_1/doc/install.101/b10131/pre_install.htm

durgabhavani — Fri, 07 Aug 2015 13:00:27 GMT

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

i.e 64 bit it seems.

durgabhavani — Fri, 07 Aug 2015 13:02:58 GMT

If qlikview and operating system both are 64 bit then which version of oracle needs to installed to connect from qlikview?