From: "The Reaper" <vorstej@sapo.co.za>
Subject: Re: HELP Needed: Problem with SQLNet
Date: 1997/07/07
Message-ID: <5pq9ct$srh@news1.saix.net>#1/1
References: <01bc8146$91cc2420$10981fc3@rdb01>
X-MimeOLE: Produced By Microsoft MimeOLE Engine V4.71.0544.0
Organization: The South African Internet Exchange.
Newsgroups: comp.databases.oracle.server



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@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@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><FONT face=3DArial size=3D2>
<P>why not using OLE for VB + VC + Borland C++ (OO2O in oracle terms) =
</P>

<P>or OCI for C C++ (OCI is cool and fast)

<P>Etienne

<P>&nbsp;</P>
 Paolo Ducoli - RDB &amp; Open Systems<RDBOSBS@MBOX.VOL.IT> wrote in =
article=20
&lt;01bc8146$91cc2420$10981fc3@rdb01&gt;...<BR>
<HTML><BODY><FONT size=3D2>We developed an application that use heavy =
ODBC calls=20
vs.<BR>
an Oracle Database<BR>
<BR>
RDBMS Oracle =
AIX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
7.2.3 or 7.2.2<BR>
TNSListener &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

unknown<BR>
Oracle=20
ODBC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;=20
1.15.3.1.0B<BR>
Required Support Files&nbsp;&nbsp;&nbsp;&nbsp; 7.3.2.2.0A<BR>
SQLNet=20
Client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;=20
2.3.2.1.6<BR>
Oracle TCP/IP adapter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.3.2.1.5<BR>
<BR>
During an heavy call (30000 rows) I get these errors in sqlnet.trc:<BR>
<BR>
many of these:<BR>
-&lt;ERROR&gt;- transport read=20
error&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;<BR>
<BR>
and once:<BR>
-&lt;ERROR&gt;- osnqrs: recieve failed, no reset marker.<BR>
disconnecting...<BR>
<BR>
so I loose the connection.<BR>
<BR>
I can't&nbsp; reproduce always that situation, sometimes (randomly)=20
everithign<BR>
seem to work ok !!<BR>
<BR>
Any suggestion ?<BR>
<BR>
Paolo Ducoli<BR>
RDB &amp; Open Systems<BR>
<A href=3D"mailto:rdbosbs@mbox.vol.it">rdbosbs@mbox.vol.it</A><BR>
<BR>
<BR>
</FONT></FONT>
</BODY></HTML>

------=_NextPart_000_01BC8AC1.05BB1840--



