Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

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

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

5 Replies
Not applicable

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

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
Honored Contributor

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

pls check database connection.

deepakk
Valued Contributor III

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

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

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

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

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

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