how i can add ip to pconnection string of oracle

Question

0.00/5 (No votes)

See more:

hi everyone

hi have oracle database on my pc
i want connect to db by ip of my pc
so
what a problem in this connection string

Password=tiger;User ID=scott;Data Source=iphere/orcl;Persist Security Info=True

thanks for any help

Posted 12-May-11 4:55am

Mostafa Elsadany

Updated 12-May-11 6:11am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yusuf · Answer 1 · 2011-05-12T05:05:00

Solution 1

everything you need to now about connection string - http://www.connectionstrings.com/[^]

Posted 12-May-11 5:05am

Yusuf

Comments

Mostafa Elsadany 12-May-11 11:11am

thnks for help
but i opened but i can solve my problem
if you know when i can write ip in this connection
please tell me

Yusuf 12-May-11 11:37am

Did you check the website? what did you see or what didn't you find there?

Mostafa Elsadany 12-May-11 11:46am

i try all examples in web site
but not working with me

Sandeep Mewara · Answer 2 · 2011-05-12T05:38:00

Solution 2

Try:
SQL Server:

Data Source=myIPAddressHere;Initial Catalog=iphere/orcl;

Come on man, don't expect a spoon feeding now. Look here for all samples: Connection strings for SQL Server[^]

Oracle:

Data Source=username/password@myIPAddressHerer//instancename;

Connection strings for Oraclehttp://www.connectionstrings.com/oracle[^]

Posted 12-May-11 5:38am

Sandeep Mewara

Updated 12-May-11 6:08am

v4

Comments

Mostafa Elsadany 12-May-11 11:44am

so what a Catalog=iphere/orcl;

Mostafa Elsadany 12-May-11 11:45am

Data Source=myIPAddressHere;Initial Catalog=myIPAddressHere/orcl;
so when password and username

Sandeep Mewara 12-May-11 11:49am

I just told you where to put the ipAddress. Rest remains same. Try!

Further updated the answer for your reference.

Mostafa Elsadany 12-May-11 11:51am

excuse me
you repeat Data Source=myIPAddressHere;Initial Catalog=myIPAddressHere/orcl;

how ?

Sandeep Mewara 12-May-11 11:54am

Sorry not excused!

Read it correctly. I have not said "Data Source=myIPAddressHere;Initial Catalog=myIPAddressHere/orcl;"

Further, I shared the link, go through it now. It's a simple thing and you want full A to Z, step by step! :doh:

Mostafa Elsadany 12-May-11 11:56am

no but by logic
Data Source=myIPAddressHere;
and Initial Catalog=myIPAddressHere/orcl;"
how together will work
any way thanks for help

Sandeep Mewara 12-May-11 12:00pm

:doh:

Try:
Data Source=IPAddressHere;Initial Catalog=myDataBaseName;User Id=myUsername;Password=myPassword;

Mostafa Elsadany 12-May-11 12:02pm

Initial Catalog' is an invalid connection string attribute
i think Initial Catalog with sql server not with oracle

Sandeep Mewara 12-May-11 12:08pm

You should clearly mention these things in your question.

Answer updated. Use it, if any doubts, please go through the link.

Mostafa Elsadany 12-May-11 12:10pm

how i can add ip to pconnection string of oracle

this my question subject