OraFAQ Forum: Forms » Connect Remote Database

Home » Developer & Programmer » Forms » Connect Remote Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connect Remote Database [message #114701]

Tue, 05 April 2005 03:27

Sabeen
Messages: 25
Registered: March 2005
Location: Pakistan

Junior Member

hello,
kindly here is my problem . would anyone help me to solve out this issue.

i have two schemas(databases 'dms_lhr and dms_rwp') both have own form modules

suppose i m in dms_lhr module connect with dms_lhr database
now i want to call dms_rwp module and also want to connect with the dms_rwp databases.

i will wait of ur reply

Report message to a moderator

Re: Connect Remote Database [message #114745 is a reply to message #114701]

Tue, 05 April 2005 08:02

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

hey....sorry I was busy in my work.
So, you want to connect from your database in lahore to a database in rawalpindi.
The easiest way for you to connect to rawalpindi's server is from a dial-up connection.

First of all you need to make changes in your tnsnames.ora file.
There you'll mention your server's IP Address(Rawalpindi's server address) and also HID Host ID (in your case dms_rwp).

For this purpose, you need to know the server's IP address.
Then you'll make a Dial-up connection in your PC.
Just like a simple dial-up connection.
Give the username and password of your Server's Database in the dial-up connection and give the telephone number to which you want to connect(in your case, Rawalpindi'r telephone number).
After estabilishing the connection, you will be connected to the Server from your home.

There's another way to connect to the server from routers but I don't think you can do it yourself.
So in your case, connecting to the server from a dial-up connection is ok.
Regards.

Report message to a moderator

Re: Connect Remote Database [message #114891 is a reply to message #114701]

Wed, 06 April 2005 02:34

Sabeen
Messages: 25
Registered: March 2005
Location: Pakistan

Junior Member

Hello, sorry i think u didn't understand my problem.
as u know i m working on distributed databases.
now i have two computers connected with each other (netwroking) ok

now i have two databases dms_lhr on one system and dms_rwp on other system.

and then i have developed two form modules dmslhr on one system and dmsrwp on other system.

ok.............

now i connect on first system that contains dms_lhr database and dmslhr module.
now problem is that ke after connecting on first system's form , i want to run dmsrwp with dms_rwp database module which in on the other system .
now can u tell me how i can do this.
both systems are at same location and networking is there to connect them.
i hope u can help me.
ok
waiting of ur reply..................
Reagards
Sabeen

Report message to a moderator

Re: Connect Remote Database [message #114901 is a reply to message #114891]

Wed, 06 April 2005 04:28

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

Oh I'm really sorry....I couldn't understand your problem.
Well....if your computers are on the network then it's simple.

You have two computers connected to the network.
Say dms_lhr is your computer and dms_rwp is other computer on the network.

You have a form in the other computer dms_rwp and you want to open that form, from a form which resides in your computer...right?
Ok....say you have two form dept and emp.
dept resides in your PC and emp resides on other PC named dms_rwp.
The path where your emp form is located is say:
\\dms_rwp\SabeenWork\emp.fmx
Now, the first and main thing is that you must have access to this folder named SabeenWork in other PC.
Now make a button n the dept form which resides in your PC.
When button pressed trigger:
OPEN_FORM('\\dms_rwp\SabeenWork\emp');

Run the dept form in your computer, Run the query in the dept form and when you'll press the button emp form will be called.

This was the explanation how we can open another form on a network.

Now you want to know how we can connect to the database residing on other computer.

For this purpose, again we need to change the entries in our tnsnames.ora file.

Open the file C:\oracle\ora92\network\admin\tnsnames.ora
I assumed that your oracle database resides in ora92.
You can check in your computer where your database resides.

Now make changes in this file . Give the server's ip address(or Host ID) and server's database id.

say server's ip address is 192.168.1.1 and database id is dms_rwp.
give these two entries, save and close the file then you can access the server's database from your computer with the syntax scott/tiger@dms_rwp.

I hope that it's clear to you now.

Regards.

Report message to a moderator

Previous Topic:	tab in text file
Next Topic:	Hi all

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 18 19:19:16 CDT 2024