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

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