none
System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

    Question

  • Hi

    As part of sql server DB Performance benchmark, i have created one console application using VS 2010.

    The application runs simple SQL Queries Cyclically.

    application works fine if the query is retriving data  less than one day data.

    the following exception i got if the query is retriving 07 Days of data

    System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

    Please help me how to resolve the issue...

    Regards

    Shree

    Thursday, July 18, 2013 4:24 AM

All replies

  • This more looks like network issue. may be, network was down that time?

    Satheesh

    Thursday, July 18, 2013 4:30 AM
  • can u plz elaborate the network down means......

    Note: The error i got only when the data retriving for more days.

    I am using the connection pooling.

    Thanks,

    Shree

    Thursday, July 18, 2013 6:38 AM