A transport-level error has occurred when receiving results from the server.(provider:TCP Provid

Hi,

I am using SQL Server 2005,

while trying to retrieve data from the database; I am getting the following

error:

A transport-level error has occurred when receiving results

from the server. (Provider: TCP Provider, error: 0 - The handle is invalid.)

But I am getting this error randomly.

Can some one help me out?
Waiting for your response

Sudhakar

Hi Sudhakar

Please can you be a little more specific.

Are you getting this error in SQL Query Analyzer? Are you getting this from some sort of Access or .NET front end application? Or is it from an ASP application?

if you provide a little more info im sure we can work this out.

Barry

|||Hi Barry,

I had developed a Web Application using ASP.Net 2005 and using SQL Server 2005 as backend ,

Please review the following code:

**************************************************************

Try
Dim con As New SqlConnection("server=101998-WEB1;database=TriMark;Integrated Security=SSPI")
con.Open()
Dim da As New SqlDataAdapter("select * from tblusers", con)
Dim ds As New DataSet
da.Fill(ds)
Catch ex As Exception
Response.Write(ex.Message)
End Try

*************************************************************

I was getting fllowing error when we try to fetch data from the database through .net application.

Error: A transport-level error has occurred when receiving results

from the server. (Provider: TCP Provider, error: 0 - The handle is invalid.)

But I am getting this error randomly.

Can some one help me to sort out this?

Waiting for your response

Sudhakar

|||

Hi, Sudhakar

To lock down the issue, can you provide the stack info when the error occured? Also, can you following the blog:http://blogs.msdn.com/sql_protocols/archive/2006/08/04/688396.aspx.

to collect ETW trace and send it to protcols@.microsoft.com

Thanks!

Ming.

|||

Is there any possibility the application uses one connection from multiple threads?

If one thread closed the connection, and another tried to use it it could generate this error.

|||Sudhakar, Can you please share with me your findings on this issue. I am seeing similar issue randomly Thanks.sql