Page 1 of 1

Lower case User Id in ConnectionString

Posted: Thu 29 Oct 2020 14:08
by samcomer
I have created a lower-case schema and user, Oracle 18c.

I can connect as this user in SQL developer by quoting the username (to prevent upper-casing), however it seems when I attempt to emulate this in my connection string, dotConnect always attempts to upper-case the user (confirmed via audit logs).

Is there a way to prevent dotConnect from upper casing the user ID parameter in the connection string?

Cheers!

Re: Lower case User Id in ConnectionString

Posted: Fri 30 Oct 2020 15:44
by Shalex
Try this way:

Code: Select all

    conn.ConnectionString = "...; User Id=\"lowerCaseName\"; ...";

Re: Lower case User Id in ConnectionString

Posted: Tue 03 Nov 2020 10:09
by samcomer
Thanks Shalex ! That seems to work fine !