Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHi, 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
Post Follow-up to this messageHi 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 > > > >
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread