topic Re: Help me to sort out the error? in QlikView

Help me to sort out the error?

durgabhavani — Mon, 10 Aug 2015 10:35:44 GMT

Hi All,

My installations:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
"CORE 11.2.0.3.0 Production"
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

Operating system:
64 BIT

Qlikview
64 BIT

But i am getting below error while connecting to DB from qlikview.

Thanks,

if you need any information apart from this, please let me know.

Thanks,

Durga

Re: Help me to sort out the error?

durgabhavani — Mon, 10 Aug 2015 10:44:07 GMT

Massimo,Gysbert,KN,Shashi... it seems you guys aware of this connectivity problem. Have a look and advice what needs to be done...

Durga

Re: Help me to sort out the error?

durgabhavani — Mon, 10 Aug 2015 17:06:35 GMT

help me in connectivity problem.

Re: Help me to sort out the error?

ecolomer — Tue, 11 Aug 2015 02:35:27 GMT

Have you tested your ODBC connection yet?

Re: Help me to sort out the error?

durgabhavani — Tue, 11 Aug 2015 03:35:06 GMT

Thanks for response colomer.

we are using OLEDB connection. How to test it?

We are directly connecting from qlikview. Steps are follow.

giving database as OLEDB,

click on connect

providing the credentials.

it establishes the connection string in qlikview.

when we are reloading, we are getting that catastrophic failure error.

Thanks,

Durga

Re: Help me to sort out the error?

vardhancse — Tue, 11 Aug 2015 04:38:07 GMT

Hi,

while trying to connect the db to qlikview will have an option to test the connection.

Re: Help me to sort out the error?

tamilarasu — Tue, 11 Aug 2015 04:48:54 GMT

Hi,

Check the below links.

Test connection failed because of an error in initializing provider

Problem with the conection

I just googled it and found the above topics. Hope this will solve your problem.

Re: Help me to sort out the error?

Anonymous — Tue, 11 Aug 2015 04:56:36 GMT

Hi Durga,

I have seen this issue before and I resolved it by ticking on the Force 32 bit option in the script. As well, make sure your drivers are 32 bit as well. See below screenshot

Re: Help me to sort out the error?

durgabhavani — Tue, 11 Aug 2015 06:44:33 GMT

Everything on my machine is 64 bit, then how can i use force 32 bit option?

Re: Help me to sort out the error?

ecolomer — Tue, 11 Aug 2015 06:46:56 GMT

It is possible your connector are in 32 bits

Re: Help me to sort out the error?

durgabhavani — Tue, 11 Aug 2015 06:50:40 GMT

Colomer,

Can i try by checking the force 32 bit?

Re: Help me to sort out the error?

ecolomer — Tue, 11 Aug 2015 06:52:52 GMT

yes,

Re: Help me to sort out the error?

maxgro — Tue, 11 Aug 2015 08:21:36 GMT

if you want to try with ODBC

The Great ODBC Confusion

regarding 32 or 64, it depends on the oracle client / driver you installed

if 64 you must use 64 in Qlik (don't check force)

if 32 , 32 in Qlik (check force)