I upgraded the users to mdac 2.7 and the problem went away.
Thomas Gaines <Thomas.Gaines_at_noaa.gov> wrote in message news:<3D90EB2B.5593CB1E_at_noaa.gov>...
> David -
>
> I just did a quickie search in Oracle's Metalink, and another customer
> had a similar issue. For her, the problem turned out to be an incomplete
> JDBC connection string. Here is a snippet from that forum:
>
> =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
> Problems was connection string was missing SID
> after jdbc:oracle:oci8:@ <--- Must add SID here.
> =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
>
> Bye,
> TG
>
> David wrote:
>
> > I wrote a vb app that uses an Oracle database. Some of the users get
> > a 12560 after do 10 queries. They are using the version 9 client.
> > It doesn't happen on my pc or my spare.
> >
> > Here is some of the trace info:
> >
> > ...
> > ...
> > nsnareceive: total bytes received: 117
> > nigini: Count in NI global area now: 76
> > nigini: Count in NI global area now: 76
> > nncpmlf_make_local_addrfile: construction of local names file failed
> > nncpmsf_make_sys_addrfile: system names file is
> > c:\oracle\ora90\network\admin\tnsnames.ora
> > nigtrm: Count in the NI global area is now 75
> > nigtrm: Count in the NL global area is now 75
> > nigini: Count in NI global area now: 76
> > nigini: Count in NI global area now: 76
> > niotns: niotns: setting up interrupt handler...
> > niotns: Not trying to enable dead connection detection.
> > niotns: Calling address:
> > (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=xx.x.xx.x)(Port=1521)))(CONNECT_DATA=(SID=coname)(CID=(PROGRAM=G:\VBAPPS\CUSTOMER
> > SERVICE\CS.EXE)(HOST=STEPHENE_PC)(USER=stephene))))
> > nscall: connecting...
> > nttgetport: port resolved to 1521
> > nttbnd2addr: using host IP address: xx.x.xx.x
> > nsopen: opening transport...
> > nttcnp: Validnode Table IN use; err 0x0
> > nttcni: trying to connect to socket 760.
> > nttcni: trying to connect to socket 760.
> > nttcni: trying to connect to socket 760.
> > nttcni: trying to connect to socket 760.
> > nttcni: trying to connect to socket 760.
> > ntt2err: soc 760 error - operation=1, ntresnt[0]=530, ntresnt[1]=55,
> > ntresnt[2]=0
> > nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=55,
> > nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
> > nsopen: unable to open transport
> > nioqper: error from nscall
> > nioqper: nr err code: 0
> > nioqper: ns main err code: 12560
> > nioqper: ns (2) err code: 0
> > nioqper: nt main err code: 530
> > nioqper: nt (2) err code: 55
> > nioqper: nt OS err code: 0
> > niqme: reporting NS-12560 error as ORA-12560
> > niomapnserror: returning error 12560
> > niotns: Couldn't connect, returning 12560
> > nigtrm: Count in the NI global area is now 75
> > nigtrm: Count in the NL global area is now 75
> > nstimarmed: no timer allocated
> > nsclose: closing transport
> > nsclose: global context check-out (from slot 0) complete
> > nigtrm: Count in the NI global area is now 74
> > nigtrm: Count in the NL global area is now 74
> > nstimarmed: no timer allocated
> > nsclose: closing transport
> > ....
> > ....
> >
> > Here is the entry from tnsnames:
> >
> > coname.world =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS =
> > (COMMUNITY = tcp.world)
> > (PROTOCOL = TCP)
> > (Host = xx.x.xx.x)
> > (Port = 1521)
> > )
> > )
> > (CONNECT_DATA = (SID = coname)
> > )
> > )
> >
> > Any help would be appreciated.
> >
> > Thanks
Received on Wed Sep 25 2002 - 13:48:28 CDT
