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

Announcements
Join us in Toronto Sept 9th 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 resolve below error?


Hi All,

Error.PNG

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

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

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

Untitled.jpg

HTH

Sasi

View solution in original post

10 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
Clever_Anjos
Employee
Employee

Can you "tnsping" your server?

It seems to be a client driver issue

Not applicable

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

sasiparupudi1
Master III
Master III

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

durgabhavani
Creator III
Creator III
Author

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


qlikmsg4u
Specialist
Specialist

try this

select * from v$version

sasiparupudi1
Master III
Master III

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

Untitled.jpg

HTH

Sasi

sasiparupudi1
Master III
Master III

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
Creator III
Creator III
Author

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

i.e 64 bit it seems.