Re: Accessing remote ORACLE data from a PC.

In article <1992Dec8.212302.8619_at_esrican.uucp> aladak_at_esri.com writes:
>I need to bring ORACLE data located on a SUN 360 to EXCEL for WINDOWS running
>on a PC. We tried using a product called SECOND WIND which runs on EXCEL. The
>product needs SQL*Net with TPC/IP installed on the PC. After trying almost
>everything under the SUN, we still get a connect error.
>
>Has anyone done anything like this successfully with either of these or another
>product? I would appreciate any suggestions or pointers.

SQL*Net requires two files to be set up correctly before it will work:

	hosts
	services

The hosts file should contain a list of the system names & IP addresses:

	IP ADDRESS		HOSTNAME	ALIAS
	128.155.001.001		XYZSYSTEM	XYZ
	128.155.001.002		ABCSYSTEM	ABC

The services file must contain the following:

        ORASRV 1525/TCP NOTE: the TCP assumes you are using TCP/IP protocol.

Bob Bailey Received on Fri Dec 11 1992 - 18:56:50 CET