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

oliverj_at_zeus.eymsl.co.nz (John Oliver) wrote:
>
> 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?
>
> Thanks for any help,
>
>
> --
> ------------------------------------------------------------------------
> John Oliver, CORE Management Systems e-mail: oliverj_at_eymsl.co.nz
> Telephone: +64-9-377-4723 Fax: +64-9-377-3554 Mobile: +64-21-652441
> Mail: PO Box 3940, Auckland, NEW ZEALAND

I also have been able to recreate the error messages. However I can get a second connection to a different Oracle server with Access and PB. Received on Fri Mar 03 1995 - 15:08:00 CET