Home » Developer & Programmer » Forms » How to connect database with static ip (Windows Server 2003)
How to connect database with static ip [message #510391] Sat, 04 June 2011 14:18 Go to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
Dear i got static ip from witribe a broadband company in pakistan i am trying to connect database from client side computer who connect with internet when i ping my server it reply with good speed but when i try to connect database the message appear (Unable to connect Destination) but it works very well with Local Area Network computers. More how can we change port 1521 in client sides

Regards

Faheem

Report message to a moderator

Re: How to connect database with static ip [message #510395 is a reply to message #510391] Sat, 04 June 2011 14:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68678
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Edit tnsnames.ora.

Regards
Michel

Report message to a moderator

Re: How to connect database with static ip [message #510408 is a reply to message #510395] Sun, 05 June 2011 09:40 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
Dear Michel Thanks for reply now at that time i successfully connect server from internet and with static ip i successfully open shared folder from server by internet but when i connect oracle database the error generate (TNS unable to connect Destination) the same tnsnames successfully job done at Local Area Net Work i only change in tnsnames host=static ip in tnsnames for internet

Regards Faheem

Report message to a moderator

Re: How to connect database with static ip [message #510409 is a reply to message #510408] Sun, 05 June 2011 09:41 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
I think there are some problems with port 1521

Report message to a moderator

Re: How to connect database with static ip [message #510410 is a reply to message #510409] Sun, 05 June 2011 09:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68678
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unless you post what works and what does not as well as your tnsnames.ora we can't help more.

Regards
Michel

Report message to a moderator

Re: How to connect database with static ip [message #510412 is a reply to message #510410] Sun, 05 June 2011 11:25 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
when we connect database through local area network it works very well but when we connect database through internet than connectivity failed and error generate (TNS unable to connect Destination)when we try to connect database via internet we give static ip in tnsnames.ora and port 1521

Report message to a moderator

Re: How to connect database with static ip [message #510417 is a reply to message #510412] Sun, 05 June 2011 12:35 Go to previous message
Michel Cadot
Messages: 68678
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sun, 05 June 2011 16:53
Unless you post what works and what does not as well as your tnsnames.ora we can't help more.

Regards
Michel

Report message to a moderator

Previous Topic: How can we change Port 1521 in forms 6i and oracle database 8.1.7
Next Topic: master-detail relations guide required
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 12 09:00:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.