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 2000 Forums
 SQL Server Administration (2000)
 linked server to Oracle

Author  Topic 

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2001-08-31 : 12:33:44
I'm trying to set up a linked server with Oracle using the OLEDB provider for Oracle. In BOL, it talkes about creating an SQL*Net alias and to see the Oracle documentation to do this. I don't have any documentation to look this up.

What I do have is a the Oracle SQL*Net client application with a successful connection to the database. Is the alias what is in the TNSNAMES file?

Anybody give me a few pointers?



   

- Advertisement -