How to query SQL Server using Oracle

[Suzie]

I was wondering if anyone knew how to query SQL Server using Oracle 8i?

I want to retrieve a recordset and then insert that same data into my tables within Oracle.

Is there a way to do this?

Thanks!

[raghavendra]

make one data base as front end.. create a dsn for another data base using that dsn name..u can talk with another data base.


------------
Suzie at 5/10/01 3:29:40 PM

I was wondering if anyone knew how to query SQL Server using Oracle 8i?

I want to retrieve a recordset and then insert that same data into my tables within Oracle.

Is there a way to do this?

Thanks!

[Martin]

Look for Oracle Heterogenous services provide by Oracle that contain 2 tools, Oracle 8i Open Connectivity and Oracle 8i Transparent Gateway that allow you to access a non-Oracle database as remote database

Here is a good book about this and how to configure it
http://www.bookpool.com/.x/maqsnzmbe0/sm/0764546996

Martin


------------
Suzie at 5/10/01 3:29:40 PM

I was wondering if anyone knew how to query SQL Server using Oracle 8i?

I want to retrieve a recordset and then insert that same data into my tables within Oracle.

Is there a way to do this?

Thanks!