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 Orcale database
into MS SQL, using third party Oracle driver via DSN entry. I'm now need to
created a linked server into Orcale, have succesfull created link servers
between MS SQL servers but NOT between MS SQL and orcale. 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

Hello Liam,

In 2K5's BOL you can find some stuff here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8a797b8e-011a-468e-a6ee-1c6dcf41277b.htm

On the web you can find some stuff here

http://support.microsoft.com/default...b;en-us;280106


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com