Re: Dev2000 with po7win95

In article <4i0mdj$7q8_at_gulfa.kuwait.net>, Rafat Sarosh <rafat_at_kuwait.net> wrote:
>I am trying to connect from DEVELOPER 2000 to PO7WIN95. After entering user
>name = scott
> password = tiger
> database = tns:Tcp-loopback.world
>my system hangs. Both are on same PC, running on win 95.
Does it hang or do you have SQL*Net V2 installed and it's looking for that host and hasn't timed out yet?
Make sure that you have a tcp-lookback in the \ORAWIN\NETWORK\ADMIN\TNSNAMES.ORA files, not the one in \ORAWIN95.

If you don't have SQL*Net V2 installed, the you want to make sure you run the \WINDOWS (16bit) install included with PO7Win95(it upgrades some components) and then you want to use 2: as the database parameter.
>
>I will appriciate any help.
>
>Regards.
>
>
>
>
>listener.ora
>-------------
>
>LISTENER =
> (ADDRESS_LIST =
>
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> )
>STARTUP_WAIT_TIME_LISTENER = 0
>CONNECT_TIMEOUT_LISTENER = 0
>TRACE_LEVEL_LISTENER = ADMIN
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = ORCL)
> )
> )
>
>
>tnsnames.ora
>-------------
>
>Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>
>
>lsnrctl file output.
>--------------------
>
>LSNRCTL> services
>Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))
>Services Summary...
> ORCL has 1 service handlers
> DEDICATED SERVER established:2 refused:0
>The command completed successfully
>
>LSNRCTL> version
>Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))
>TNSLSNR for WINDOWS 32: Version 2.2.2.0.0 - Production
> TNS for WINDOWS 32: Version 2.2.2.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for WINDOWS 32: Version 2.2.2.1.0
>-
>Production
> Windows 32 Named Pipes IPC NT Protocol Adaptor for WINDOWS 32: Version
>2
>2.2.1.0 - Production
> Windows 32 TCP/IP NT Protocol Adapter for WINDOWS 32: Version
>2.2.2.1.0
>- Production
>The command completed successfully
>
Received on Mon Mar 11 1996 - 00:00:00 CET