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.
Answer by sp_lock ·
Follow the link below. It uses scripts to create the link, but will give you the same results.