Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue on Reload of the script, failed to connect database--"null password given; logon denied"

Hi there,

When I try to run the following script on QlikView 10 i get error dialogue:

ODBC CONNECT TO [odbcConnection;DBQ=orcl_instance];
SQL SELECT "ACT_ID",
"ANP_NAME",
"CMP_ID"
FROM "ROCWARE_REFERENCE"."ACTION_PIN";

SQL##f - SqlState: 28000, ErrorCode: 1005, ErrorMsg: [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied

ODBC CONNECT TO [sbxrwtst1;DBQ=SBXRWTST1]





1 Solution

Accepted Solutions
Not applicable
Author

I didn't try debugging, this was happening in QV 10 and Oracle client: SQL*Plus: Release 11.2.0.1.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.

-Sid

View solution in original post

5 Replies
Not applicable
Author

I'm facing the following error on reload:

SQL##f - SqlState: 28000, ErrorCode: 1005, ErrorMsg: [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied

ODBC CONNECT TO [odbcConnection;DBQ=orcl_instance]

Please suggest.

-Sid

suniljain
Master
Master

pls check database connection.

deepakk
Partner - Specialist III
Partner - Specialist III

hi Sid,

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.

Not applicable
Author

Hi Sunil/Deepak,

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]

-Sid

Not applicable
Author

I didn't try debugging, this was happening in QV 10 and Oracle client: SQL*Plus: Release 11.2.0.1.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.

-Sid