Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2012-04-17 : 08:27:31
|
Hiwe need to fetch the data from REMOTE SERVER Here we need to create Linked server to connet that remote serveri have an idea on creating LINKED SERVER in SSMSMY REMOTE SERVER IS :ORACLEDESTINATION SERVER IS: SQL SERVER 2008I need to connect ORACLE SERVER FROM SQL SERVERhere i want to know the clarification about PROVIDERSHow can we can make Linked server and how can we make different providers in SQL database can anybody explain us simple procedure. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-17 : 13:33:41
|
the provider detail depends on type of source you want to connect to.See common connection string information for most sources belowhttp://www.connectionstrings.com/the provider will be chosen based on version and type of source------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|