Linked Server SQL Server-> Oracle

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 SQL Server-> Oracle

Author

Topic

ramdas
Posting Yak Master

181 Posts

Posted - 2003-02-21 : 15:58:21

Hi,
I have a issue using Linked Server with Oracle. I am not able to see the oracle tables though I can connect to the Oracle database.

sp_addlinkedserver 'Oracle_Test', 'Oracle', 'MSDAORA',
'test'

The last parameter is supposed to be the SQL*Net
alias name (I used 'test' as shown above). I am not
sure what it means, but I assumed it is the same as
what I specify in my tnsnames.ora file for oracle.

My Oracle SQL*Net Configuration file (tnsname.ora) has
the following section:
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = RVITEST01)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = RVITEST01)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = TEST)
)
)

Any ideas why I can't see the tables.

Ramdas Narayanan
SQL Server DBA

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-02-21 : 16:22:35

Can you query any tables via linked server syntax, or using OPENQUERY? I had similar problems where I could not see Oracle tables but I could query them fine.

ramdas
Posting Yak Master

181 Posts

Posted - 2003-02-21 : 16:36:49

Thank you
Bye

Ramdas Narayanan
SQL Server DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources