Re: A transport-level error has occurred when receiving results from the server.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



You would want to check the SQL Server error logs to make
sure it's not a refused connection from an issue like full
logs, out of disk space, etc. Those would be in the SQL log.
If you don't have anything there and it's random then you
may be experiencing network burps and dropping connections.
You can following the troubleshooting steps in the following
article:
How to troubleshoot network connectivity problems
http://support.microsoft.com/?id=325487

-Sue

On Mon, 23 Apr 2007 13:27:10 -0700, Audrey Ng
<odd26uk@xxxxxxxxxxx> wrote:

Hi all,

I am getting the error below:
I would like to also mention that this error is occuring randomly. I am
running a web application under SQL Server 2005 and .NET framework 2.0.
Has anyone encountered this issue.

Error occurred during report data retrieving and binding.
The actual error message is:

A transport-level error has occurred when receiving results from the
server. (provider: TCP Provider, error: 0 - The specified network name
is no longer available.)

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateO
bject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateOb
ject stateObj, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.GetDataLength(SqlMetaDataPriv colmeta,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.ProcessColumnHeader(SqlMetaDataPriv col,
TdsParserStateObject stateObj, Boolean& isNull) at
System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) at
System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean
setTimeout) at
System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) at
System.Data.SqlClient.SqlDataReader.GetValues(Object[] values) at
System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataRea
der.GetValues(Object[] values) at
System.Data.ProviderBase.SchemaMapping.LoadDataRow() at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at private_enterprise_report_cmn_RepricingSummary.Page_Load(Object
sender, EventArgs e) in

*** Sent via Developersdex http://www.developersdex.com ***

.



Relevant Pages

  • A transport-level error has occurred when receiving results from the server.
    ... asyncResult, TdsParserStateObject stateObj) at ... dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) ... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String ... startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior ...
    (microsoft.public.sqlserver.connect)
  • RE: Access Excel data
    ... at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, ... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String srcTable, ... startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) ...
    (microsoft.public.dotnet.framework.interop)
  • Very strange SQL connection problem
    ... System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ... System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.adonet)
  • Server Error in /MyWebForm Application
    ... SQL connection in VS.NET 2003, I test the connection and everything works ... MSDE server. ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • ADO.NET TableAdapter "The connection is closed" error
    ... The TableAdapter was generated by Visual Studio 2005 ... Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, ... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String ... Oracle Client 9.2.01 ...
    (microsoft.public.dotnet.framework.adonet)