General discussion

Locked

Linking an Oracle Database to SQL Server

By John Greeson ·
How do you link an Oracle Database into SQL Server 7.0 so that you can query the Oracle Database through SQL Server? What needs to be done on the Oracle side and what needs to be done on the SQL Server side.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Linking an Oracle Database to SQL Server

by RodSherer In reply to Linking an Oracle Databas ...

I am trying to do just the opposite (query the SQL Server database from an Oracle instance), and to do this you use the Oracle Heterogeneous Services. Unfortunately, I am missing one key detail: the agent which actually is the bridge between the two. I have a question posted which hopefully will give me that one detail. I don't know where to get it, or how to access it if it comes with the Oracle or SQL Server installation.

Maybe this is what you need as well. Look on the Oracle Technet Web site and look into those heterogeneous services. Maybe this will work for what you want to do too.

Collapse -

Linking an Oracle Database to SQL Server

by John Greeson In reply to Linking an Oracle Databas ...

The question was auto-closed by TechRepublic

Collapse -

Linking an Oracle Database to SQL Server

by Ambily In reply to Linking an Oracle Databas ...

Setting up a hetrogenous agent and database integration is described very well in the book :
Oracle 8i and Microsoft Sql Server 2000 Integration by Stephan Chelack.

You can get this book from Amazon.com

Hope that helps

Collapse -

Linking an Oracle Database to SQL Server

by John Greeson In reply to Linking an Oracle Databas ...

The question was auto-closed by TechRepublic

Collapse -

Linking an Oracle Database to SQL Server

by John Greeson In reply to Linking an Oracle Databas ...

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums