Post reply

Error information - work around provided.

  • December 3, 2004 at 6:49 am

    #60021

    I have a stored procedure that normally run correctly.  As of this week, when trying to run the stored procedure from query analyzer, we get the following error:

    [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (WrapperRead()).

    Server: Msg 11, Level 16, State 1, Line 0

    General network error. Check your network documentation.

     
    Connection Broken
     
    I researched the error and found that others have also received the error - but no resolution seemed to be found. 
     
    I did find a way around it - I'm just not sure why it works.  So, running the procedure in SQL Query Analyzer directly on the SQL Server's console (not terminal services!) AND forcing Analyzer to connect using TCP instead of named pipes is the only way I was able to get the SP to run to completion.
     
    So, now that we know this...does anyone have any idea what the error means or what the work around might imply?
     
    Thanks
     
    Ryan

  • December 3, 2004 at 7:43 am

    #532443

    I've seen this sometimes with strange data coming back, like something corrupts the TDS stream. Can you do a select * from each of the tables, which might narrow down where the issue is.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply