Oracle TNS:12203 and Win95 Help!

From: Casey Sisterson <csisters_at_mb.sympatico.ca>
Date: 1996/11/28
Message-ID: <329E6439.370E_at_mb.sympatico.ca>#1/1


Howdy!

I am in need of the experts out there.
I am trying to connect to Oracle 7.2.2.4.0 on Novell 4.1 with SQL*Net V2.2 using a client of Win95 and SQL*Net V2.3. I am using SPX as the protocol.

The 16bit version of SQL*Net V2.3 works great. I have no problems with that. But I cannot connect using Windows 95 and the 32 bit version.

I get a TNS:12203 error every time I try... I have traced it and here is an portion of it:

[info deleted]
connecting...
(DESCRIPTION=(CONNECT_DATA=(SID=ORCL) (CID=(PROGRAM=OraPgm) (HOST=Windows 95PC)(USER=csisterson)) (SERVER=dedicated) (CLIENT_REGISTRATION=Sisterson95)) (ADDRESS=(COMMUNITY=spx.world) (PROTOCOL=SPX) (Service=ORASRV))) opening transport...
-<ERROR>- error on socket 511 - ntresnt[0], ntresnt[1]=0,ntresnt[2]=8558176
-<ERROR>- nsres: id=0, op=65, ns=12541, ns2=12560, nt[0]=511, nt[1] = 0, nt[2]=0
-<ERROR>- unable to open transport

Call failed...
[more info deleted]
Processed all addresses in address list. Failed to make contact. Result descriptor: 12203, 12541, 511, 0
Result descriptor: 12224, 12541, 511, 0 from Interchange: Exiting NRICALL with following termination result -1
-<ERROR>- error from nricall
-<ERROR>- nr err code: 12203
-<ERROR>- ns main err code: 12541
-<ERROR>- ns (2) err code: 12560
-<ERROR>- nt main err code: 511
-<ERROR>- ns (2) err code: 0
-<ERROR>- nt OS err code: 0
-<ERROR>- Couldn't connect, returning 12203

If anybody out there could help me out on how to set up a connection to Oracle using the 32bit Drivers, I would be in your debt.

I have to get the 32bit drivers working as I am trying to connect to Oracle using Powerbuilder.

Thanks for all of your help!                 

Casey Sisterson (csister_at_mb.sympatico.ca) Received on Thu Nov 28 1996 - 00:00:00 CET

Original text of this message