OraFAQ Forum: Networking and Gateways » Database Link “Oracle & SQL Server”

Home » RDBMS Server » Networking and Gateways » Database Link “Oracle & SQL Server”

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Link “Oracle & SQL Server” [message #161595]

Mon, 06 March 2006 03:57

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Hi

Please advise how to make a database link:

From Oracle(9i Release 2) to SQLServer(2000)
And
From SQLServer(2000) to Oracle(9i Release 2)

Thanks
Jawad

Report message to a moderator

Re: Database Link “Oracle & SQL Server” [message #161633 is a reply to message #161595]

Mon, 06 March 2006 06:54

orausern
Messages: 826
Registered: December 2005

Senior Member

for the first part,
you have to use Oracle9i Heterogeneous Connectivity. You can refer to :

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96544/toc.htm

for its details.

Report message to a moderator

Re: Database Link “Oracle & SQL Server” [message #161645 is a reply to message #161595]

Mon, 06 March 2006 08:01

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Thanks Niravshah

Any other easy option?

Wishes
Jawad

Report message to a moderator

Re: Database Link “Oracle & SQL Server” [message #161648 is a reply to message #161645]

Mon, 06 March 2006 08:10

orausern
Messages: 826
Registered: December 2005

Senior Member

there may be one...just that i donot know it.

Report message to a moderator

Re: Database Link “Oracle & SQL Server” [message #161865 is a reply to message #161595]

Tue, 07 March 2006 10:01

ramsat
Messages: 49
Registered: November 2005

Member

Hai,

This can be done very esily using Oracle Heterogenous Services. There Are amny site which will help u much better
I mean Oracle to Sql server----
Find any problem then pls revert me i will do my level best

Thank U
bye

Report message to a moderator

Previous Topic:	Login with Cellphone
Next Topic:	ORA-12505 when connecting to new instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 07:17:50 CDT 2024