OraFAQ Forum: Forms » How to Connect Different databases from a form

Home » Developer & Programmer » Forms » How to Connect Different databases from a form (form 10g,Win XP)

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

How to Connect Different databases from a form [message #502518]

Wed, 06 April 2011 23:50

maddyd2k
Messages: 24
Registered: November 2010

Junior Member

Hi All,
In my application i need connect different databases from a form
How can i do that?????

Help me....

Thanks

Report message to a moderator

Re: How to Connect Different databases from a form [message #502537 is a reply to message #502518]

Thu, 07 April 2011 01:53

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Simultaneously? If so, perhaps you'd rather use database links.

Report message to a moderator

Re: How to Connect Different databases from a form [message #502551 is a reply to message #502537]

Thu, 07 April 2011 03:27

maddyd2k
Messages: 24
Registered: November 2010

Junior Member

Thanks for your reply..

Can you please tell me a bit clearly

Thanks

Report message to a moderator

Re: How to Connect Different databases from a form [message #502556 is a reply to message #502551]

Thu, 07 April 2011 04:03

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, if you could ask a question clearly, we could answer clearly as well.

What I meant was: if your form is supposed to fetch data from tables that belong to different databases, I think that you shouldn't switch from one database to another (i.e. connect to USER_A/PW_A@DB_A and then to USER_B/PW_B@DB_B etc.), but create database links and use them while manipulating data in all those tables.

On the other hand, maybe a distributed database is what you really need. Or, maybe something else; I can't tell, you provided too few information.

Report message to a moderator

Re: How to Connect Different databases from a form [message #502558 is a reply to message #502556]

Thu, 07 April 2011 04:32

maddyd2k
Messages: 24
Registered: November 2010

Junior Member

Thank you
Distributed database link is very helpful

Report message to a moderator

Previous Topic:	Dynamic Report by using Oracle Forms 6i
Next Topic:	Insert Tags

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 12:52:29 CDT 2024