problem if username or password contains special characters

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Tobsel
Posts: 15
Joined: Fri 28 May 2010 12:31

problem if username or password contains special characters

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

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

Post by Pinturiccio » Thu 15 Mar 2012 13:11

We have fixed the bug with unicode user names in the Direct mode in dotConnect for Oracle 6.70.302. For more information please refer to http://www.devart.com/dotconnect/oracle ... story.html

You can upgrade to the latest version if your subscription is valid. Otherwise, we recommend you upgrading to the latest version 6.70.311.

Post Reply