Connect with quoted username

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jfudickar
Posts: 202
Joined: Fri 10 Mar 2006 13:03
Location: Oberursel / Germany

Connect with quoted username

Post by jfudickar » Tue 15 Jan 2013 22:18

Hi,

why is it needed to quote a username like "jens.fudickar" in the logon dialog?

I thought it was possible to connect without the quotes in older releases.

Regards
Jens

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Connect with quoted username

Post by AlexP » Wed 16 Jan 2013 09:00

Hello,

This is the correct behaviour: case-sensitive usernames and usernames containing special characters must be double-quoted. Such behaviour is implemented in other applications working with Oracle, including standard SQLPlus and Oracle SQL Developer.

jfudickar
Posts: 202
Joined: Fri 10 Mar 2006 13:03
Location: Oberursel / Germany

Re: Connect with quoted username

Post by jfudickar » Wed 16 Jan 2013 09:15

.but it should be possible to add the quotes automaticly when something like a a dot is included.ä
This would be user friendly.

Regards
Jens

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Connect with quoted username

Post by AlexP » Wed 16 Jan 2013 09:52

Hello,

Since Oracle supports case-sensitive usernames, we cannot quote usernames automatically, as, the case, in which a username was entered, will be used. Moreover, this will be components behaviour change, that can lead to errors in working applications.

Post Reply