Lower case User Id in ConnectionString

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
samcomer
Posts: 3
Joined: Thu 29 Oct 2020 13:57

Lower case User Id in ConnectionString

Post by samcomer » Thu 29 Oct 2020 14:08

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!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Lower case User Id in ConnectionString

Post by Shalex » Fri 30 Oct 2020 15:44

Try this way:

Code: Select all

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

samcomer
Posts: 3
Joined: Thu 29 Oct 2020 13:57

Re: Lower case User Id in ConnectionString

Post by samcomer » Tue 03 Nov 2020 10:09

Thanks Shalex ! That seems to work fine !

Post Reply