Topic: how do i connect with more than one databases.

how do i connect with more than one databases.

2 posts in topic

Flat View

Thread View

Older Post First | Reply to Topic

TOPIC ACTIONS:

Print Topic

Posted By: saravanan_ekambaram
Posted On: Monday, October 22, 2001 11:47 PM

Iam having data's in two different database. one in oracle and another in db2. i want to select particular columns from two different tables which is in different databases. how can i do it. Give me some sample code also. Is it possible with out using any third party component.
thank you

-Sara

Report | Quote This | Send private message | Reply | Print

Re: how do i connect with more than one databases.

Posted By: Bernie_Acs
Posted On: Wednesday, November 7, 2001 12:48 PM

There is a product which can be obtained from Oracle know as Transparent Gateways which would allow for acess to various other databases from within the context of the Oracle Database session using the distributed query mechanics. This may be an option but it is not free and has some limitation in terms of datatypes and automatic conversions thereof ( mostly with abstract datatypes ). A new version of this technology supports a generic ODBC connect which can connect to a very wide variety of thrid party vendor databases.

Report | Quote This | Send private message | Reply | Print

Re: how do i connect with more than one databases.

Posted By: Bozidar_Dangubic
Posted On: Tuesday, October 23, 2001 06:11 AM

can't do it in a single statement. you need to go to oracle and get what you need from there then go to db2 and get what you need from there.

Report | Quote This | Send private message | Reply | Print