Urgent help with error

9 May 2005 4:27 PM

Chris

Hi,
I have a storedproc that wasworking fine for a year then all of a sudden it
throwing this error

(1 row(s) affected)

2

(1 row(s) affected)

2

(1 row(s) affected)

[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

Any ideas?

9 May 2005 4:55 PM

Rick Sawtell

Show quote Hide quote

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:E235D4D7-00AE-49D6-A9BB-193E284462BD@microsoft.com...
> Hi,
> I have a storedproc that wasworking fine for a year then all of a sudden
it
> throwing this error
>
> (1 row(s) affected)
>
> 2
>
> (1 row(s) affected)
>
> 2
>
> (1 row(s) affected)
>
>
> [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
>
>
> Any ideas?

Have you applied any service packs lately? What MDAC version are you
currently running? What does the sproc look like?

More information would be helpful.

Rick Sawtell
MCT, MCSD, MCDBA

9 May 2005 7:34 PM

Chris

I didn't apply any service packs, however, I did run updates available from
WIN UPDATES SITE. I have the latest version of MDAC installed and the SP is
HUGH. The SP was working fine until today.

Show quoteHide quote

"Rick Sawtell" wrote:

>
> "Chris" <Ch***@discussions.microsoft.com> wrote in message
> news:E235D4D7-00AE-49D6-A9BB-193E284462BD@microsoft.com...
> > Hi,
> > I have a storedproc that wasworking fine for a year then all of a sudden
> it
> > throwing this error
> >
> > (1 row(s) affected)
> >
> > 2
> >
> > (1 row(s) affected)
> >
> > 2
> >
> > (1 row(s) affected)
> >
> >
> > [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
> >
> >
> > Any ideas?
>
>
> Have you applied any service packs lately? What MDAC version are you
> currently running? What does the sproc look like?
>
> More information would be helpful.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>
>