C# Oracle Connectionstring

Question

I've got a little problem between oracle and C#. I can't seem to connect to my database(=localhost) within my application. I'm using Oracle XE11.2. The error occurs everytime I'm calling "conn.Open()" and Oracle returns this error: {"ORA-12154: TNS:could not resolve the connect identifier specified"}.

I'm 100% sure that the User Id and the Password are correct because I can login to the database via SQL Developer. I think the problem might be in the data source but I'm not sure. Anyone who can help out?

Here is my code:

string connstring = "Data Source=xe;User Id=Software;Password=Software";

//Open connection
OracleConnection conn = new OracleConnection(connstring);
conn.Open();

Sorry, I forgot to tell you that the database was running on localhost. I adapted the post. — Guido
– Guido, Commented Oct 19, 2015 at 20:06

Rajesh · Accepted Answer · 2015-10-19 19:32:15Z

1

Did you try tns ping "tnsping xe" from the machine where you are running your program?

answered Oct 19, 2015 at 19:32

Rajesh

9610 bronze badges

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

1 Comment

Guido Over a year ago

Thank you, running tnsping xe was the solution. After I adjusted the data source it worked!

Collectives™ on Stack Overflow

C# Oracle Connectionstring

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related