ORA-01005: null password given; logon denied

ORA-01005: null password given; logon denied

Postby slaxman » Fri 31 Aug 2012 19:37

When the password is created with double quotes, devart connection fails with exception message 'ORA-01005: null password given; logon denied'. Oracle allows passwords surrounded by double quotes to allow special characters to be part of password.

This code will result in exception. Please advise.

Devart.Data.Oracle.OracleConnection conn = new Devart.Data.Oracle.OracleConnection();
conn.Server = "hostname";
conn.ServiceName = "myservicename";
conn.Port = 1521;
conn.UserId = "TEST";
conn.Password = "\"Hello!\"";
conn.Direct = true;
conn.Open();
slaxman
 
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

Re: ORA-01005: null password given; logon denied

Postby Pinturiccio » Mon 03 Sep 2012 14:46

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2045
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01005: null password given; logon denied

Postby Pinturiccio » Tue 11 Sep 2012 14:11

We have changed the behaviour: the quote symbols will be ignored in the password value in the Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.
As a workaround use the following code:
Code: Select all
conn.Password = "Hello!";
Pinturiccio
Devart Team
 
Posts: 2045
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01005: null password given; logon denied

Postby slaxman » Tue 11 Sep 2012 15:01

that partly fixes the problem. How would you handle passwords with space in them such as "Hello World!"?
slaxman
 
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

Re: ORA-01005: null password given; logon denied

Postby Shalex » Tue 18 Sep 2012 14:30

The "Hello World!" password works OK in our environment using the 7.2.77 version of dotConnect for Oracle:
Code: Select all
conn.Password = "Hello World!";

Are you getting any exception?
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: ORA-01005: null password given; logon denied

Postby slaxman » Thu 20 Sep 2012 18:30

you are right. There are no exceptions while connecting which I thought might happen because the password had to be double quoted originally while creating the user. Please let us know when the double quote issue (ORA-01005: null password given; logon denied
) is fixed.
slaxman
 
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

Re: ORA-01005: null password given; logon denied

Postby Pinturiccio » Wed 03 Oct 2012 08:03

We have changed the behaviour: the quote symbols will be ignored in the password value in the Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.
Pinturiccio
Devart Team
 
Posts: 2045
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01005: null password given; logon denied

Postby Pinturiccio » Fri 05 Oct 2012 09:30

The new build of dotConnect for Oracle 7.2.96 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=25020
Pinturiccio
Devart Team
 
Posts: 2045
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle