|
Hello, I need to create a linked server.. and I am not very clear about the configuration steps in the creation of a linked server. The objective here is to create link to an oracle db through sqlserver ssms I am not sure what is the information i need to provide for the following columns. All i have right now is access to the oracle db. ie username and pwd. these are the steps i am following to create a linked server right click --> server objects-->create new linked server --> entering the following information -- linked server : Linkedserver001 Server type : other datasource provider : Microsoft OLEDB provider for Oracle product name : Oracle Data source........... what info should i provide Provider String: --- what info should i provide here Next tab: Under security checked in provided remote login and pwd next tab.. server Options all are default settings. Any inputs.. Thanks
(comments are locked)
|
|
Follow the link below. It uses scripts to create the link, but will give you the same results. http://www.sqlmag.com/article/sql-server/setting-up-an-oracle-linked-server49687.aspx or
(comments are locked)
|
