Re: Personal Oracle 8 and Developer 2000 (Again)

From: <sharadudyawar_at_my-dejanews.com>
Date: Fri, 06 Nov 1998 04:00:44 GMT
Message-ID: <71ts9c$4vg$1@nnrp1.dejanews.com>

Colm Hogan

Unfortunately PO8 does not allow direct connection from Developer 2000. You will have to do a few more things.

This is waht worked for me.
1. Set up TCPIP protocal on you machine. 2 Give your PC a TCPIPIP address using Settings/Control Panel/Network eg your TCPIP address may be 200.100.50.25 3. Install complete PO8(you may have already done it) 4. Create or edit the file C:\ORAWIN95\NET80\ADMIN\LISTENER.ORA as follows LISTENER =
(ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = 200.100.50.25)


          (Port = 1521)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )

5.In your Windows 95 registry, change the value of HKLM\Software\ORACLE\LISTENER_STARTUP to "AUTO".

6. Using SQL Net Easy Configuration create a new service called "colm" with the server = 200.100.50.25 and service = ORCL.

Your C:\ORAWIN95\NET80\ADMIN\TNSNAMES.ORA file should now have an entry like the following.

colm.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host =  200.100.50.25)


          (Port = 1521)


        )
        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host =  200.100.50.25)


          (Port = 1526)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

7 Restart your PC once . Now you should be able to connect from D2K using SCOTT/TIGER_at_colm.

Hope this helps.

Sharad

In article <36419A84.7780_at_respironics.com>, Colm.Hoban_at_respironics.com wrote:

> I know this question has been asked before but at the time it didn't
> apply, so apologies for the repetition.
>
> How can I connect Dev2K to the Personal Oracle 8 DB on my PC. I keep
> getting all kinds of TNS errors.
>
> Thanks in advance,
> Colm Hoban.
>


-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

Received on Thu Nov 05 1998 - 22:00:44 CST