dcsimg
<strong>how do i connect with more than one databases.</strong>
2 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

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

Re: <strong>how do i connect with more than one databases.</strong>

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.

Re: <strong>how do i connect with more than one databases.</strong>

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.
About | Sitemap | Contact