Re: SQL*Net 2.x, Win95, SPX

I have used that type of connection for 7.2 , and now, 7.3 database connectivity. ( Netware Intranetware Client for Win95, SqlNet 2.x.x )---

One thing to note is that the TNSNAMES.ORA that Win95 apps use is in the Orawin95/network/admin directory, not the one the 16-bit Win3.1 apps use ( the one in Oracle.ini) ... Check this first, and if that's not the problem, let me know by E-Mail

John.Greco_at_dot.state.mn.us
Oracle DBA
MnDOT Human Resource Office

dKing_at_accBusSol.com (Daniel King) wrote:

>Hi
>
>I am having some difficulty setting up a Win95 workstation to connect to
>my Oracle v7.2 database via SQL*Net v2.2 or v2.3, using the SPX
>protocol.
>
>I have several Win 3.1 clients which successfully connect using the same
>TNSNAMES.ORA I am attempting to use on the Win95 client.
>
>I have had no success with either the MicroSoft "IPX/SPX Compatible"
>protocol included in Win95, or with the latest available download version
>of Novell's "Intranetware Client 32 for Windows 95".
>
>sqlnet.log shows the following:
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 2.3.3.0.0 - Production
> NOVELL SPX/IPX NT Protocol Adapter for 32-bit Windows: Version
>2.3.3.0.0 - Production
> Time: 29-MAY-97 17:20:45
> Tracing to file: D:\ORAWIN95\BIN\sqlnet.trc
> Tns error struct:
> nr err code: 12203
> TNS-12203: TNS:unable to connect to destination
> ns main err code: 12541
> TNS-12541: TNS:no listener
> ns secondary err code: 12560
> nt main err code: 511
> TNS-00511: No listener
> nt secondary err code: 0
> nt OS err code: 0
>
>All of which appears to indicate (on the surface) that the Listener is
>not available. The listener is definitely available when this error
>stack is produced, so the only thing I can think of is that Oracle's SPX
>adapter on the Win95 workstation is not communicating with the SPX
>protocol stack on that workstation.
>
>Has anyone been able to get this configuration to work? If so, what was
>required?
>
>Any information greatly appreciated.
>
>Thanks
>Dan
>
Received on Mon Jun 02 1997 - 00:00:00 CDT