Re: HELP Needed: Problem with SQLNet

From: The Reaper <vorstej_at_sapo.co.za>
Date: 1997/07/07
Message-ID: <5pq9ct$srh@news1.saix.net>#1/1

This is a multi-part message in MIME format.

------=_NextPart_000_01BC8AC1.05BB1840
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

why not using OLE for VB + VC + Borland C++ (OO2O in oracle terms)=20 or OCI for C C++ (OCI is cool and fast)
Etienne

Paolo Ducoli - RDB & Open Systems wrote in article =
<01bc8146$91cc2420$10981fc3_at_rdb01>...

We developed an application that use heavy ODBC calls vs. an Oracle Database

RDBMS Oracle AIX           7.2.3 or 7.2.2
TNSListener            unknown
Oracle ODBC                1.15.3.1.0B
Required Support Files     7.3.2.2.0A
SQLNet Client              2.3.2.1.6
Oracle TCP/IP adapter      2.3.2.1.5

During an heavy call (30000 rows) I get these errors in sqlnet.trc:

many of these:

-<ERROR>- transport read error                         =20

and once:
-<ERROR>- osnqrs: recieve failed, no reset marker. disconnecting...

so I loose the connection.

I can't reproduce always that situation, sometimes (randomly) = everithign
seem to work ok !!

Any suggestion ?

Paolo Ducoli
RDB & Open Systems
rdbosbs_at_mbox.vol.it

------=_NextPart_000_01BC8AC1.05BB1840
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML 3.2//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"Trident 4.71.0544.0"' name=3DGENERATOR>

</HEAD>
<BODY>
why not using OLE for VB + VC + Borland C++ (OO2O in oracle terms) =


or OCI for C C++ (OCI is cool and fast)

Etienne

 

Paolo Ducoli - RDB & Open Systems<RDBOSBS_at_MBOX.VOL.IT> wrote in = article=20
<01bc8146$91cc2420$10981fc3_at_rdb01>... 
<HTML><BODY>We developed an application that use heavy =
ODBC calls=20
vs. 
an Oracle Database 
 

RDBMS Oracle =
AIX          =20 7.2.3 or 7.2.2 
TNSListener            =

unknown 
Oracle=20
ODBC           &nb= sp;   =20
1.15.3.1.0B 
Required Support Files     7.3.2.2.0A SQLNet=20
Client           &= nbsp; =20
2.3.2.1.6 
Oracle TCP/IP adapter      2.3.2.1.5 
 

During an heavy call (30000 rows) I get these errors in sqlnet.trc: 
 

many of these: 
-<ERROR>- transport read=20
error           &n= bsp;           &nb= sp;   
 

and once: 
-<ERROR>- osnqrs: recieve failed, no reset marker. disconnecting... 
 

so I loose the connection. 
 

I can't  reproduce always that situation, sometimes (randomly)=20 everithign 
seem to work ok !! 
 

Any suggestion ? 
 

Paolo Ducoli 
RDB & Open Systems 
<A href=3D"mailto:rdbosbs_at_mbox.vol.it">rdbosbs_at_mbox.vol.it</A> 
 
 

</BODY></HTML>

------=_NextPart_000_01BC8AC1.05BB1840-- Received on Mon Jul 07 1997 - 00:00:00 CDT