Home -> Usenet -> comp.databases.oracle -> Multiple SQL/Net TCP/IP for Windows Connections?

Multiple SQL/Net TCP/IP for Windows Connections?

From: John Oliver <oliverj_at_zeus.eymsl.co.nz>
Date: 1 Mar 95 21:59:02 GMT
Message-ID: <2119559.79142.8604_at_zeus.eymsl.co.nz> 






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
Received on Wed Mar 01 1995 - 22:59:02 CET












Original text of this message