Multiple SQL/Net TCP/IP
From: Gary Nilges <gnilges_at_tyrell.net>
Date: Thu, 2 Mar 1995 21:40:47 GMT
Message-ID: <D4u1K0.F1q_at_tyrell.net>
Date: Thu, 2 Mar 1995 21:40:47 GMT
Message-ID: <D4u1K0.F1q_at_tyrell.net>
A>We are running Oracle SQL*Net V2 and SQL*Net TCP/IP for Windows, with A>Powerbuilder, ERWin and MS Access clients. A> A>Our problem is is that a workstation can only ever have one datatase A>connection open at a time. Opening a second connection from Powerbuilder A>gives an error "ORA-06107: NETTCP: ORACLE network server not found". A>Opening a second connection from an ODBC client such as MS Access gives A>an error "ODBC - connection to '<databasename>' failed" A> A>It matters not whether the second connection is from the same class of A>client, or to the same server database. It just seems that you can only A>have one client connection to an Oracle server from the PC. A> A>Is this a problen with SQL*Net TCP/IP for Windows, or is something A>configured wrong here? A>
It was expained to me once that you can only have one connection from a Windows SQL*Net client because Windows is not a true multitasking environment.
...gary
--- * UniQWK v3.3a* The Windows Mail ReaderReceived on Thu Mar 02 1995 - 22:40:47 CET