Page 1 of 1

Direct Mode: quoted username

Posted: Fri 07 May 2010 12:28
by martin82
I have an issue concerning odac in direct mode (BDS 2006 with odac 6.90.0.57)
How can i connect to a database with a case-sensitive username?

For example a connectstring like:

Code: Select all

"Peter"/pwd@server:port:service
fails with 'ORA-01017: invalid username/password' although i can see in sys.aud$ that there was a new login attempt for user Peter

If i don't use direct mode,

Code: Select all

"Peter"/pwd@service
works fine..

Are quoted usernames not supported in direct mode?
Thanks

Posted: Tue 11 May 2010 07:25
by bork
Hello

Thank you for information. We have reproduced your issue. We will notify you as soon as we have any result.

Posted: Thu 27 May 2010 12:38
by bork
Hello

This is a restriction of the protocol that is used by the Direct mode. We will investigate the possibility of solving this issue in one of the next builds/versions of ODAC. But now we don't recommend you to use case-sensitive UserName in the Direct mode.