topic Re: Null password given; logon denied- Oracle Connection issue QMC in QlikView

Null password given; logon denied- Oracle Connection issue QMC

gayatri7 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to connect to Oracle DB via reload task in QMC. I have given the below code in script for connection

LET vConnectionName = SubField(vConnections,'|',1) ;

LET vDSN = subfield(vConnections,'|',2) ;

LET vUserID = subfield(vConnections,'|',3) ;

LET vPassword = subfield(vConnections,'|',4) ;

Let vSchema = subfield(vConnections,'|',5);

// Connect to Database

ODBC CONNECT TO $(vDSN) (XUserId is $(vUserID) , XPassword is $(vPassword) );

and below parameter in Reload tab

MOGROUP|Test_DSN|Test_User|Test|Admin;

while running the task m getting below error

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

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

Could any one please help me!!

Re: Null password given; logon denied- Oracle Connection issue QMC

Anil_Babu_Samineni — Fri, 13 Oct 2017 07:18:43 GMT

Connection can save random Username and Passwords using ANSI standards and you are providing constant Username and Password that may the cause. Can you connect normally I meant without any variable for connect string.

Re: Null password given; logon denied- Oracle Connection issue QMC

gayatri7 — Fri, 13 Oct 2017 07:24:20 GMT

Thanks for you reply!!

I dont have Oracle DB in my desktop. So I cant try connection directly.Task is actually connecting to server where Oracle DB is present.

However, earlier also I have given the constant userid and password. It connected successfully.

Could you please help me understand what could be the other reasons.

Thanks

Re: Null password given; logon denied- Oracle Connection issue QMC

Anil_Babu_Samineni — Fri, 13 Oct 2017 07:26:22 GMT

I am not sure, What does vConnections? Could be wrong values storing in variable..