Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Linking to Oracle9I

Author  Topic 

coagulance
Yak Posting Veteran

78 Posts

Posted - 2008-04-30 : 08:59:17
Sorry If I have posted this in the wrong head,

I would like to Establish connectivity to a Oracle9i DB thro Linked Server, Can any of you guide me to suitable links...
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-30 : 09:03:43
http://msdn.microsoft.com/en-us/library/ms190479.aspx
Go to Top of Page

coagulance
Yak Posting Veteran

78 Posts

Posted - 2008-04-30 : 09:07:11
Thanks Visakh,

Would like to know more on the Oracle Server side settings...needed
Go to Top of Page

coagulance
Yak Posting Veteran

78 Posts

Posted - 2008-05-01 : 14:14:49
Can any one suggest me :
1. Should I Install Client Components on the SQLServer machine ?
2. Is there any other settings , Changes I need to make on the Oracle DB ?
2. How do I get the @datasrc parameter ? for sp_addlinkedserver

Any help would be greatly apppreciated.
Go to Top of Page
   

- Advertisement -