Creating Linked Server into Oracle  
Author Message
JonWard





PostPosted: Thu Mar 09 17:11:32 CST 2006 Top

SQL Server >> Creating Linked Server into Oracle

Hi Folks,

Pretty new to linked servers, however I need to create a linked server from
MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I already
have successfull DTS application which takes info from the Oracle database
into MS SQL, using third party Oracle driver via DSN entry. I'm now need to
created a linked server into Oracle, have succesfull created link servers
between MS SQL servers but NOT between MS SQL and Oracle. I have checked the
web but finding it hard to come across good instructions. I would appreciate
if anyone can point me to a good web sites or instructions. Can I use my
third party driver(DSN) in creating a linked server?

thanks,
liamo

SQL Server284  
 
 
Randall





PostPosted: Thu Mar 09 17:11:32 CST 2006 Top

SQL Server >> Creating Linked Server into Oracle Actually, I'm a newbie at it and creating the linked server for Oracle was
really easy. Just go to Server Objects, Linked Servers in SQL Server
management Studio, right click on Linked Servers, pick New Linked Server and
populate the dialog when it comes up. You'll want to use the MSDAORA
provider. My provider string looks like:

Provider=MSDAORA;Data Source=zzzzzz.world;User ID=xxxxxx;Password=yyyyyyy
(substitute appropriate values). zzzzz.world goes into Product name field
in my case. Done!

Randall Arnold



> Hi Folks,
>
> Pretty new to linked servers, however I need to create a linked server
> from
> MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I
> already
> have successfull DTS application which takes info from the Oracle database
> into MS SQL, using third party Oracle driver via DSN entry. I'm now need
> to
> created a linked server into Oracle, have succesfull created link servers
> between MS SQL servers but NOT between MS SQL and Oracle. I have checked
> the
> web but finding it hard to come across good instructions. I would
> appreciate
> if anyone can point me to a good web sites or instructions. Can I use my
> third party driver(DSN) in creating a linked server?
>
> thanks,
> liamo