Connection Broken

• kirkor maydozian

  Old Hand

  Points: 320

  More actions

  November 3, 2004 at 2:38 am

  #65228

  Hi,

  while execting a SP in Query Analyzer I'm geting the following error message:

  "[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (InvalidParam()).

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

  General network error. Check your network documentation.

  Connection Broken"

  This message shows while QA is retriving the result set

  The server is located in my local network and the other users don't have the same problem.

  thanks

   

   

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  November 3, 2004 at 5:23 am

  #528755

  I have received this message in the past.  The only thing that I have done is shut down QA and re-open it.  The query then executes fine.  Another thing to check however if this happens often is how do you connect to your SQL server (Named pipes or TCP/IP)?

  Try experimenting between the two and see which is more reliable.  As a general rule TCP/IP in a LAN will outperform named pipes but they will beat TCP/IP in a WAN.

   

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• kirkor maydozian

  Old Hand

  Points: 320

  More actions

  November 3, 2004 at 6:40 am

  #528763

  Thanks AJ,

  it worked after shut down and re-open of QA.

  bye