Re: Connecting SQL Server 7 database to Oracle Database Server

Jack: I user SQL Server 2000 to Oracle 8i/9i. I'm not sure if in SQL 7.0, there is a concept of linked server(s) --- most likely they do ---, but in SQL 2000 I create them through SQL Analyzer (or through the wizard) using the following command:
user master
go
exec sp_addlinkedserver
-- linked server name you want to use
 'OracleSvr',
--description
 'Oracle 8i',
--protocol
 'MSDAORA',
--SID Name. Must match your TNSNAMES.ora file  '8iDB.DOMAIN.COM'
go

and then, you can query it by using the following: select * from openquery(OracleSvr, 'select * from SCHEMA.TABLE_NAME') go

Alex Ivascu
DBA "Jack" <jack.wilson_at_orst.edu> wrote in message news:92ef2205.0204051213.12734940_at_posting.google.com...
> Hi there,
>
> I am running a SQL Server (version 7) wherein I am trying to utilize
> the link server manager from the enterprise manager to connect to a
> Oracle database server located in another domain. It has not work. I
> have read where I need to install SQL*NET for this to work. I do have
> Oracle 8.1.6 installed on my SQL Server. Apparently NET8 has replaced
> SQL*NET? I am trying to comprehend on how to configure this so I can
> link the SQL server to the Oracle database server utilizing the link
> server tool in SQL enterprise management. I am new to this and
> haven't a clue on how to accomplish this linking? Any suggestions are
> welcomed. Thanks......
>
> Jack
Received on Sat Apr 06 2002 - 21:37:00 CST