Re: Multiple SQL/Net TCP/IP for Windows Connections?

In article <3j4kjt$7o6_at_asterix.uninova.pt>, ppf_at_uninova.pt (Pedro Pimentel) says:
>
>In article <2119559.79142.8604_at_zeus.eymsl.co.nz>, oliverj_at_zeus.eymsl.co.nz (John Oliver) says:
>>
>>We are running Oracle SQL*Net V2 and SQL*Net TCP/IP for Windows, with
>>Powerbuilder, ERWin and MS Access clients.
>>
>>Our problem is is that a workstation can only ever have one datatase
>>connection open at a time. Opening a second connection from Powerbuilder
>>gives an error "ORA-06107: NETTCP: ORACLE network server not found".
>>Opening a second connection from an ODBC client such as MS Access gives
>>an error "ODBC - connection to '<databasename>' failed"
>>
>>It matters not whether the second connection is from the same class of
>>client, or to the same server database. It just seems that you can only
>>have one client connection to an Oracle server from the PC.
>>
>>Is this a problen with SQL*Net TCP/IP for Windows, or is something
>>configured wrong here?
>
> I've experienced the same error some time ago. It was because of some buggy layer
>(I think it was the SQL*Net stuff on the PC). Try to define the connecton string
>as T:ip_address/port:base_name instead of T:server_name:base_name. It will
>work fine this way.
>
>--
>Pedro Pimentel
>Faculdade de Ciencias e Tecnologia / Universidade Nova de Lisboa
>Portugal
>e-mail: ppf_at_uninova.pt

T:ip_address/port:base_name won't likley work. This is a SQL V1 connect string. I've seen similar problems ....

What vendors IP stack are you running ? ( like Novell Lan Workplace or FTPs )

Set TRACE_LEVEL_CLIENT = USER in the SQLNET.ORA file ... usually found in c:\orawin\network\admin
Read the trace produced. it is pretty criptic but usually you'll find a tidbit.

Regards
GAG Received on Fri Mar 03 1995 - 04:51:38 CET