Search code examples
c#oracle-database.net-coreoracle12c

C# .net Core Connection string is not well-formed

I've changed my driver for connection to Oracle and got error

Connection string is not well-formed

I had unofficial Oracle driver dotNetCore.Data.OracleClient Version=1.0.0

Now I use Oracle.ManagedDataAccess.Core Version=2.18.3

My connection string looks like there

Data Source = ORACLE.HOSTS:1521/pdb_prod;PERSIST SECURITY INFO=True;USER ID=xxxx; Password=xxxx;Pooling=false;

And it works well before

Whats wrong with my connection string?

Solution

  • Problem detected - the connection string is read from ENV, and at the end of the connection string there was a newline character.

    My admins are the best, but even they sometimes make mistakes