details on Linked server setup

Hi,

Any one know about Linked server setup in sql server.

I want to know more detail on setting up a sqlserver to connect it directly
to an oracle server. So that I can directly access data's from Oracle using
Stored procedure.


Regards,
Sasikumar Balasubramanian

Hi

There is an example using the  Microsoft Driver in sp_addlinked server
http://msdn.microsoft.com/library/d.../>
a_8gqa.asp.
Depending on the driver you are using you may also need to install SQL*NET
etc..

This article gives the steps required:
http://support.microsoft.com/defaul...kb;en-us;280106

Oracle OLEDB drivers can be found at
http://www.oracle.com/technology/so...e_db/index.html

John

"sasikumar" wrote:

> Hi,
>
> Any one know about Linked server setup in sql server.
>
> I want to know more detail on setting up a sqlserver to connect it directl
y
> to an oracle server. So that I can directly access data's from Oracle usin
g
> Stored procedure.
>
>
> Regards,
>  Sasikumar Balasubramanian
>
>
>
>