As I can see in your connection, you have not mention the USerid and password.
(If your using ODBC connection)
When you click on the Connect Button a small pop up with user id comes up. Select the DSN connection you have created and enter the userid and password. if it is authenticated, it will provide u a connection string with userid and password.
One more reason for the error might be :
Since you are not entering userid and password in your above connection string ,the table which you are trying to pull might have access restriction like anynomus cannot access the data.
Check with ur DB for authentication.
My DB connectivity is fine.
The query I have pasted here is generated automatically based on selections made by me.
Before I make any selections QlikView pops up dialogue on selecting connect for user id and pwd I have provided the same.
Could you please let me know the connection string with userid and pwd:
my connection string looks like:
ODBC CONNECT TO [odbcConnection_name;DBQ=orcl_instance_name]
I didn't try debugging, this was happening in QV 10 and Oracle client: SQL*Plus: Release 22.214.171.124.0 Production on Wed Mar 16 12:45:42 2011.
I installed QV9 and it started working.
Note: When I run reload on QV9 it asks for user name and password for ODBC connect and it does reload. But in case QV 10 it did never ask for any user name and pwd for ODBC connection.