ORA-01005: null password given; logon denied

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
slaxman
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

ORA-01005: null password given; logon denied

Post by 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();

Pinturiccio
Devart Team
Posts: 2141
Joined: Wed 02 Nov 2011 09:44

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

Post by 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: 2141
Joined: Wed 02 Nov 2011 09:44

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

Post by 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!";

slaxman
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

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

Post by 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!"?

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

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

Post by 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?

slaxman
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

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

Post by 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.

Pinturiccio
Devart Team
Posts: 2141
Joined: Wed 02 Nov 2011 09:44

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

Post by 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: 2141
Joined: Wed 02 Nov 2011 09:44

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

Post by 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

Post Reply