Database Link supported with Oracle 9i?

I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.comYes, you can access Oracle from SQL Server via a linked server, provided you
have the required oracle drives (SQL*Net I believe) installed on the SQL
Server box. SQL Server Books Online has examples. See sp_addlinkedserver and
sp_addlinkedsrvlogin in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ken McClaren" <kmcclare@.hotmail.com> wrote in message
news:e$FC1CmbEHA.904@.TK2MSFTNGP09.phx.gbl...
I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@.hotmail.com|||These KB articles might help you incase you run into any issues.
Q280106 HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL
Q259959 INFO: Steps to Debug Connectivity Issues to an Oracle Server
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I've had a number of problems upgrading from 8i to 9i and in the end
I've stayed with the 8i client on the sql server and that works
perfectly. I'm sure I read somewhere that 9i hasn't been fully tested by
MS, although I might have dreamt that!
g.
http://www.sqlskunkworks.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!