|
Home > Archive > MS SQL Server > March 2006 > Creating Linked Server into Oracle
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Creating Linked Server into Oracle
|
|
| Liam Mac 2006-03-09, 11:23 am |
| 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
| |
| Randall Arnold 2006-03-09, 8:23 pm |
| 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;Dat
a Source=zzzzzz.world;User ID=xxxxxx;Password=y
yyyyyy
(substitute appropriate values). zzzzz.world goes into Product name field
in my case. Done!
Randall Arnold
"Liam Mac" <LiamMac@discussions.microsoft.com> wrote in message
news:577A3DAE-9EE3-4CEA-91F4- CADFA442FFF4@microso
ft.com...
> 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
|
|
|
|
|