MS SQL Server - details on Linked server setup

Author

details on Linked server setup

sasikumar

2006-01-31, 3:23 am

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

John Bell

2006-01-31, 3:23 am

Hi

There is an example using the Microsoft Driver in sp_addlinked server
http://msdn.microsoft.com/library/d..._adda_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 directly
> to an oracle server. So that I can directly access data's from Oracle using
> Stored procedure.
>
>
> Regards,
> Sasikumar Balasubramanian
>
>
>
>

Sponsored Links