Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

Help me to sort out the error?

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,

Error.PNG

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

Thanks,

Durga

12 Replies
durgabhavani
Creator III
Creator III
Author

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

Durga

durgabhavani
Creator III
Creator III
Author

help me in connectivity problem.

ecolomer
Master II
Master II

Have you tested your ODBC connection yet?

durgabhavani
Creator III
Creator III
Author

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

vardhancse
Specialist III
Specialist III

Hi,

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

tamilarasu
Champion
Champion

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.

scriptina.jpg

Anonymous
Not applicable

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

32Bit.png

durgabhavani
Creator III
Creator III
Author

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

ecolomer
Master II
Master II

It is possible your connector are in 32 bits