ORA-01005: null password given; logon denied
ORA-01005: null password given; logon denied
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();
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();
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ORA-01005: null password given; logon denied
We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ORA-01005: null password given; logon denied
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:
As a workaround use the following code:
Code: Select all
conn.Password = "Hello!";
Re: ORA-01005: null password given; logon denied
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
The "Hello World!" password works OK in our environment using the 7.2.77 version of dotConnect for Oracle:
Are you getting any exception?
Code: Select all
conn.Password = "Hello World!";
Re: ORA-01005: null password given; logon denied
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.
) is fixed.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ORA-01005: null password given; logon denied
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ORA-01005: null password given; logon denied
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
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