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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Linked server provider

Author  Topic 

kond.mohan
Posting Yak Master

213 Posts

Posted - 2012-04-17 : 08:27:31
Hi

we need to fetch the data from REMOTE SERVER
Here we need to create Linked server to connet that remote server

i have an idea on creating LINKED SERVER in SSMS

MY REMOTE SERVER IS :ORACLE

DESTINATION SERVER IS: SQL SERVER 2008

I need to connect ORACLE SERVER FROM SQL SERVER

here i want to know the clarification about PROVIDERS

How 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 below

http://www.connectionstrings.com/

the provider will be chosen based on version and type of source

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -