Direct Mode: quoted username

martin82 · Post by **martin82** » Fri 07 May 2010 12:28

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

bork · Post by **bork** » Tue 11 May 2010 07:25

Hello

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

bork · Post by **bork** » Thu 27 May 2010 12:38

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.