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

[#1]

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]

[#2]

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]

pls check database connection.

[deepakk]

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.

[#5]

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

[#6 · Accepted solution]

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