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

Question

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?

@Badda_Bing my connection string looks same like in this site — Igor Cova
– Igor Cova, Commented Feb 6, 2019 at 19:32
Does using capitals matter? PERSIST SECURITY INFO; USER ID...? — Badda_Bing
– Badda_Bing, Commented Feb 6, 2019 at 19:38
@Badda_Bing I didn't try it, do you think it may help to me? — Igor Cova
– Igor Cova, Commented Feb 6, 2019 at 19:44

Derviş Kayımbaşıoğlu · Accepted Answer · 2019-02-07 12:54:36Z

1

Don't put space between equalities Data Source = ...

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

you can also try

Data Source=//host:[port]/[service_name]

Btw, I dont have experience with Pooling=true you may try without it and if it succeeds you can add it

answered Feb 7, 2019 at 12:54

Derviş Kayımbaşıoğlu

30.9k4 gold badges55 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Igor Cova Over a year ago

Problem was detected - connection string is reading from ENV and there it was newline character in the end of the connection string. =) My admins are the best, but even they sometimes make mistakes

Igor Cova · Accepted Answer · 2019-02-07 13:06:04Z

1

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

answered Feb 7, 2019 at 13:06

Igor Cova

3,6145 gold badges35 silver badges60 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related