Page 1 of 1
ORA-01005: null password given; logon denied
Posted: Fri 31 Aug 2012 19:37
by slaxman
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();
Re: ORA-01005: null password given; logon denied
Posted: Mon 03 Sep 2012 14:46
by Pinturiccio
We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.
Re: ORA-01005: null password given; logon denied
Posted: Tue 11 Sep 2012 14:11
by Pinturiccio
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:
Re: ORA-01005: null password given; logon denied
Posted: Tue 11 Sep 2012 15:01
by slaxman
that partly fixes the problem. How would you handle passwords with space in them such as "Hello World!"?
Re: ORA-01005: null password given; logon denied
Posted: Tue 18 Sep 2012 14:30
by Shalex
The "Hello World!" password works OK in our environment using the 7.2.77 version of dotConnect for Oracle:
Are you getting any exception?
Re: ORA-01005: null password given; logon denied
Posted: Thu 20 Sep 2012 18:30
by slaxman
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.
Re: ORA-01005: null password given; logon denied
Posted: Wed 03 Oct 2012 08:03
by Pinturiccio
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.
Re: ORA-01005: null password given; logon denied
Posted: Fri 05 Oct 2012 09:30
by Pinturiccio
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