Re: Connecting Personal Oracle 8 and Developer 2000

From: <sharadudyawar_at_eudoramail.com>
Date: Sat, 07 Nov 1998 07:20:53 GMT
Message-ID: <720scl$kfr$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 what 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 values for "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.
>

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 Sat Nov 07 1998 - 01:20:53 CST