Re: Connecting SQL Server 7 database to Oracle Database Server

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sat, 6 Apr 2002 06:16:59 +1000
Message-ID: <a8l0q4$ca9$1@lust.ihug.co.nz>

Can't help you on the SQL Server side of things, but yes: Net8 is the new improved version of SQL Net. And if you go to my web site and have a look at Tips/Networking, you'll discover how to configure Net8 for direct connections to the Oracle database, and maybe that will help you get your SQL Server connection going.

Sorry not to be of more help.

Regards
HJR

--
-----------------------------------------------
Resources for Oracle : http://www.hjrdba.com
===============================

"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 Fri Apr 05 2002 - 14:16:59 CST