Re: Connection Broken Error

From: mvp (mvp_at_discussions.microsoft.com)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 08:25:03 -0800

Hi Keith,
I am not on server, i am running cursor from my m/c in query analyzer. In my
client net work utility
rightnow there are two protols 1) TCP/IP and 2) Named pipes.
I do not know what is going on. pls let me know.

thx,
mvp

"Keith Kratochvil" wrote:

> I did a quick search and I could not find much with that error:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q827452
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q317261
>
> http://groups-beta.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/b76c7b6ff78bd53e/53922b8b490d9e0f?
>
> Are you running the cursor through Query Analyzer or within an app?
> What protocol are you using to connect to SQL Server?
> If you execute the cursor via Query Analyzer when you are sitting at the
> server does it work?
>
> --
> Keith
>
>
> "mvp" <mvp@discussions.microsoft.com> wrote in message
> news:2CF2E59D-B18B-4E40-BD13-FE038B4610C5@microsoft.com...
> > Hello everybody,
> > I am running a simple cursor and it has arround 10 thousand rows to loop.
> > But after sometime i am getting connection broken error. Exact error
> message
> > is as following.
> >
> >
> > [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 Broken
> >
> >
> > Do u have any idea, Pls let me know asap.
>
>

Relevant Pages

  • Re: Connection Broken Error
    ... Query which gives a lot of rows, und I get the same error. ... > I am not on server, i am running cursor from my m/c in query analyzer. ...
    (microsoft.public.sqlserver.programming)
  • Re: VB connection to SQL server
    ... > the client machine begins to lose its relevance and accuracy as soon as it ... > aware that the data is probably out of date, a client sided cursor might ... > design minimises the possibility that records will have changed in the ... >> The Database server is in the office, and people use the Vb program from ...
    (microsoft.public.vb.database)
  • Re: Huge memory comsumption of ADODB Connection object
    ... unless the cursor is returning data to the client* I don't see ... I suppose this could cause some extra memory ... Is there a similar behavior in Sybase? ... Server was originally based on that rdbms, so there very well may be. ...
    (microsoft.public.data.ado)
  • Re: VB connection to SQL server
    ... "Chris Barber" wrote in message ... > recordsets (client side cursor) to allow you to persist the recordsets to ... aware that the data is probably out of date, a client sided cursor might fit ... That is because the SELECT statement is executed on the server and the data ...
    (microsoft.public.vb.database)
  • Re: ADO server side cursor sloooow
    ... Using the ODBC driver my tests show that both client and server side ... forward only server side cursor is faster than a client side cursor as ... requiring over 1000 trips over the network. ...
    (comp.databases.btrieve)
Loading