transport-level error

• sek-1110234

  SSC Enthusiast

  Points: 174

  More actions

  July 31, 2009 at 5:16 am

  #208805

  Hi,

  when I am running my application i am getting the following error:

  A transport-level error has occurec when receiving results from the server

  (provider:TCP Provider,error:0-The Specified network name is no longer available)

  my application is processing huge data.its more than one lakh records.

  I already kept Connection Timeout=0 in connection string and set command.CommandTimeOut=0 for each executing command.

  Hope you all knows it means the application waits for reponse from server what ever be the time the server takes.

  what are the reasons to get this error and how to resolve this?

  thanks in advance.

• binko

  Default port

  Points: 1408

  More actions

  July 31, 2009 at 6:52 am

  #1032895

  see if someone else had the same issue:

  http://www.google.com/search?hl=en&client=opera&rls=en&ei=vehyStWWDY-MNqrd6bAM&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=A+transport-level+error+has+occurred+when+receiving+results+from+the+server&spell=1

• Sanz

  Hall of Fame

  Points: 3412

  More actions

  July 31, 2009 at 3:20 pm

  #1033180

  Check your errorlogs to know more about the kind of error you are getting. It can be an error related to your SQL Server or it can be something outside SQL Server(network issues, connection issues etc..)

  Sanz

• Vivek Shukla

  SSCrazy

  Points: 2146

  More actions

  August 5, 2009 at 6:02 am

  #1034703

  please make sure you are connected to server. sql server generates this message when connection to server is lost.

  Vivek Shukla - MCTS SQL Server 2008