How to access an SQL server Database thru Oracle

[isonlyme]

Hi all,

I have Oracle 8i and Sql server 2000, the user needs to to querys on both databases. Question:

How can I merge or combine the 2 databases so the user can do queries as if there were only one database but accessing tables on both Databases?

Is this possible?

Thanks in advance

 

[did02]

Hi,

To access an SQLServer DB from your oracle DB you have to implement heterogeneous services on your oracle serveur.
For more information, read the oracle doc.
I never tried it so I can't help you more.
Rgds,
Did02

 

[isonlyme]

thanks for pointing me to the right direction!!!!