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

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(SqlExc eption exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateO
bject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadSni Error(TdsParserStateOb
ject stateObj, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni (DbAsyncResult
asyncResult, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPac ket(Int32
bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByt e()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byt e token,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.GetDataLength(SqlM etaDataPriv colmeta,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.ProcessColumnHeade r(SqlMetaDataPriv col,
TdsParserStateObject stateObj, Boolean& isNull) at
System.Data.SqlClient.SqlDataReader.ReadColumnHead er(Int32 i) at
System.Data.SqlClient.SqlDataReader.ReadColumn(Int 32 i, Boolean
setTimeout) at
System.Data.SqlClient.SqlDataReader.GetValueIntern al(Int32 i) at
System.Data.SqlClient.SqlDataReader.GetValues(Obje ct[] values) at
System.Data.ProviderBase.DataReaderContainer.Commo nLanguageSubsetDataRea
der.GetValues(Object[] values) at
System.Data.ProviderBase.SchemaMapping.LoadDataRow () at
System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(Data Set 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(Data Set 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.Pag e_Load(Object
sender, EventArgs e) in
*** Sent via Developersdex http://www.codecomments.com ***
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@.yahoo.co.uk> 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(SqlExc eption exception,
>Boolean breakConnection) at
>System.Data.SqlClient.TdsParser.ThrowExceptionAnd Warning(TdsParserStateO
>bject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadSn iError(TdsParserStateOb
>ject stateObj, UInt32 error) at
>System.Data.SqlClient.TdsParserStateObject.ReadSn i(DbAsyncResult
>asyncResult, TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadPa cket(Int32
>bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByt e()
>at System.Data.SqlClient.TdsParser.GetTokenLength(Byt e token,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.GetDataLength(Sql MetaDataPriv colmeta,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.ProcessColumnHead er(SqlMetaDataPriv col,
>TdsParserStateObject stateObj, Boolean& isNull) at
>System.Data.SqlClient.SqlDataReader.ReadColumnHea der(Int32 i) at
>System.Data.SqlClient.SqlDataReader.ReadColumn(In t32 i, Boolean
>setTimeout) at
>System.Data.SqlClient.SqlDataReader.GetValueInter nal(Int32 i) at
>System.Data.SqlClient.SqlDataReader.GetValues(Obj ect[] values) at
>System.Data.ProviderBase.DataReaderContainer.Comm onLanguageSubsetDataRea
>der.GetValues(Object[] values) at
>System.Data.ProviderBase.SchemaMapping.LoadDataRo w() at
>System.Data.Common.DataAdapter.FillLoadDataRow(Sc hemaMapping mapping) at
>System.Data.Common.DataAdapter.FillFromReader(Dat aSet 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(Data Set 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.Pag e_Load(Object
>sender, EventArgs e) in
>*** Sent via Developersdex http://www.codecomments.com ***
|||I'm not sure if this is related to the issue but when I do try to
connect to my database server from a Remote Management Studio. I get the
same error
"A transport-level error has occurred when receiving results from the
server..."
Any ideas?
*** Sent via Developersdex http://www.codecomments.com ***
|||You still need to go through the other steps - check the
logs, check the network connectivity, etc.
-Sue
On Tue, 24 Apr 2007 06:32:28 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:

>I'm not sure if this is related to the issue but when I do try to
>connect to my database server from a Remote Management Studio. I get the
>same error
>"A transport-level error has occurred when receiving results from the
>server..."
>Any ideas?
>
>*** Sent via Developersdex http://www.codecomments.com ***
sql