Page 1 of 1
Case sensitive login and password in ODAC 7.20.0.6
Posted: Fri 20 May 2011 06:27
by VadimShvarts
Dear users,
New ODAC version 7.20 is available for download now.
This version includes:
...
Case sensitive login and password in the Direct mode is supported
Unicode login and password in the Direct mode is supported
...
I try to check this functionality.
If UserName or Password has character ' ' (space) I could not connect to server.
In OCI mode also.
Oracle server 10.2.0.4.0 or Oracle server 11.2.0.1.0
Delphi XE
ODAC v7.20.0.6 Direct mode
Please fix.
Test project was sended to support devart com
Thanks
Posted: Fri 20 May 2011 08:15
by AlexP
hello,
Unfortunately, we did not receive your example, please send it once more to Alexp*devart*com.
I created a user as
Code: Select all
CREATE USER "Test Test" IDENTIFIED BY "Test Test";
GRANT CREATE SESSION TO "Test Test";
and was able to connect successfully in the direct and OCI modes.
Posted: Mon 23 May 2011 05:45
by VadimShvarts
I send test project to Alexp
Use test.sql
Code: Select all
create user "Иванов Петр" identified by "русСкий_паРоль";
create user "Иванов_Петр" identified by "русСкий паРоль";
grant connect to "Иванов Петр";
grant connect to "Иванов_Петр";
conn "Иванов Петр"/"русСкий_паРоль"@metatest
conn "Иванов_Петр"/"русСкий паРоль"@metatest
Posted: Mon 23 May 2011 07:05
by AlexP
Hello,
As you are creating case-sensitive login and password, and there is the space symbol used, you should use quotes when writing them in ODAC as well as in SQL Plus.
Posted: Mon 23 May 2011 09:41
by VadimShvarts
AlexP wrote:
As you are creating case-sensitive login and password, and there is the space symbol used, you should use quotes when writing them in ODAC as well as in SQL Plus.
It works.
Thanks