DBnetlib connectionread (wrapperRead()) error

hi ,
I have a sp which executes without any problems when
called from query analyser, but when I call it in loop
then I get this error !!! any clues.
my calling sp goes like this.
open cursor
fetch..
do while
exec sp1 ...
..
fetch..
end
the sp1 is called for 2-3 counts and this error is
reported.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionRead (WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection BrokenAfter MUCH struggling I found I was returning a larger then average
packet size, using the print statement throughout my development
version of my stored Proc. Try commenting out unnecessary print
statements or move your packet size up in your query client.
Example: SQL Server Query Analyzer..
File/Configure/New Connections (tab)/ increase packet size.
BTW: I only had this problem with SQL Query Analyzer.. If you're using
this tool it's time to switch to a real mans tool.. DB Artisan! You'll
never look back.|||Hi Sandeep Nachankar,
I do not have the answer to your problem. What I do have
is a situation similar to yours " a stored procedure
processing records within a loop resulting in General
Network Error - ConnectionRead(WrapperRead) error".
I was just wondering if you figure out what your problem
was in order to point me in the right direction in
assisting with mine.
Thanks for all the help.
Mark P.
email: zramonn@.msn.com

>--Original Message--
>After MUCH struggling I found I was returning a larger
then average
>packet size, using the print statement throughout my
development
>version of my stored Proc. Try commenting out unnecessary
print
>statements or move your packet size up in your query
client.
>Example: SQL Server Query Analyzer..
>File/Configure/New Connections (tab)/ increase packet
size.
>BTW: I only had this problem with SQL Query Analyzer.. If
you're using
>this tool it's time to switch to a real mans tool.. DB
Artisan! You'll
>never look back.
>.
>