problem if username or password contains special characters
Posted: Fri 09 Mar 2012 10:22
Hello,
I use devart 6.10.141.0 to Oracle in direct mode. The problem is that it is not possible to connect if the password contains characters like ä,ö,ü,Ä,Ö,Ü.
I always get the exception that the username or password is wrong. Connection works with others tools and the oracle client.
Example:
var conn = new OracleConnection();
conn.UserId = "löl";
conn.Password = "löl";
conn.Direct = true;
conn.Server = "140.147.2.5";
conn.Sid = "schrempp";
conn.Port = 1521;
conn.Unicode = true;
var erg = conn.ConnectionString;
conn.Open();
I tried to replace the "ö" with & # 2 4 6 ; like shown below but that doesnt solve the problem.
conn.UserId = "l& # 2 4 6 ;l";
conn.Password = "l& # 2 4 6 ;l";
Is there a solution for that problem?
Thank you very much
I use devart 6.10.141.0 to Oracle in direct mode. The problem is that it is not possible to connect if the password contains characters like ä,ö,ü,Ä,Ö,Ü.
I always get the exception that the username or password is wrong. Connection works with others tools and the oracle client.
Example:
var conn = new OracleConnection();
conn.UserId = "löl";
conn.Password = "löl";
conn.Direct = true;
conn.Server = "140.147.2.5";
conn.Sid = "schrempp";
conn.Port = 1521;
conn.Unicode = true;
var erg = conn.ConnectionString;
conn.Open();
I tried to replace the "ö" with & # 2 4 6 ; like shown below but that doesnt solve the problem.
conn.UserId = "l& # 2 4 6 ;l";
conn.Password = "l& # 2 4 6 ;l";
Is there a solution for that problem?
Thank you very much