0

I have a connection string in my web.config that is a normal one, as the connection strings that we have for sql database but this one is for oracle database that is found on a server on our network.

I think i am filling some fields wrong, like the port(i dunno what it is), sid (same issue).

I am getting this error:

listener refused the connection with the following error ora-12505

Any help is appreciated.

Improve this question
2
  • A connection string for SQL Server is very different from a connection string for Oracle. You might check here to get examples of properly formatted connection strings. Good luck. Commented Jul 9, 2013 at 11:53
  • post your connection string Commented Jul 9, 2013 at 11:53

1 Answer 1

Reset to default
1

The SID is the name of the database instance. The error message indicates you've got it wrong.

Edit the default value for the port is 1521, for the SID is ORCL. Both parameters are configured in the tnsnames.ora file on the database server.

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

1 Comment

thank you for your answer, it is 100% right i will give you an upvote and the correct answer in few minutes (i can't now)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.