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
 General SQL Server Forums
 New to SQL Server Administration
 How To Create DB Link In MsSqlServer To Oracle10g

Author  Topic 

rakeshgautam1233
Starting Member

5 Posts

Posted - 2011-07-22 : 08:51:59
Hi ,
I want to use the data from Oracle 10g and SQL Server 2005 at a time.SQLServer is local for me and Oracle is remote.For this I need to create a DBlink to Oracle from SqlServer(Like it is possible in Oracle using heterogeneous Service ).
Please tell me the steps for creating DBLink.
As it is very urgent please reply ASAP.
Thanks in advance.

regards:Rakesh

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-22 : 09:21:36
Create a Linked Server
Go to Top of Page

rakeshgautam1233
Starting Member

5 Posts

Posted - 2011-07-22 : 09:39:53
thanks!
Go to Top of Page
   

- Advertisement -