Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am able to connect oracleXE from qlick vie 11.Connection was successful but when clicking on reload i am getting following error.
Can anybody please help on this issue. I am new to Qlickview
SQL##f - SqlState: S1000, ErrorCode: 12170, ErrorMsg: [Oracle][ODBC][Ora]ORA-12170: TNS:Connect timeout occurred
ODBC CONNECT TO [QlickOracleXEDSN;DBQ=XE] (XUserId is GSJeWZFPTDdKWWBQ, XPassword is DZaQRZFPTDdKWWNJ)
Can you share your script?
Can you please check on Force 32 Bit and try reload?
Hi Sreeni,
I tried but it is giving error.Do i need to install qlickview server.I am not able to see any services related to qlickview in my machine.
Whatever you might think:
1) You don't have a LOAD statement in your script - only an ODBC CONNECT
2) This ODBC CONNECT is failing when you execute your load script
3) The ODBC CONNECT statement has either a wrong USERID and/or wrong PASSWORD specified.
These are stored in the XUserID and XPassword as hashed values. When they don't work you will typically
get this request for User Name and Password by the dialog box you have shown.
4) This obviously fails too - although the error message tells about a timeout not password error...
It is still hard for me to judge exactly where your error is.
The normal thing to do when you have a CONNECT ODBC is immediately to create a LOAD statement by pressing the SELECT button. Maybe that is what you are doing? But you told me that you do a reload... So what is the case?
Hi Peter,
Thanks for travelling with me. I have sloved my issue.