Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 transport-level error

Author  Topic 

sek
Starting Member

27 Posts

Posted - 2009-07-30 : 07:30:02
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 and command.CommandTimeOut=0.
Hope you all knows it means the application waits for reponse from server what ever be the time the server takes.

But Still I am getting the above error.

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

thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-07-30 : 12:47:42
That error means you got disconnected from the database server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

sek
Starting Member

27 Posts

Posted - 2009-07-31 : 00:26:35
How to solve this issue?as my application needs to be run daily. numbers of users connected to the server is so many and the data needs to be processed is huge.how to resolve this issue???

in my application all queries are inline queries.

can you please suggest some solution to my problem.

thanks for your reply.

regards,
sekhar
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-02 : 01:16:12
You'll need to figure out if the server actually went down or if you experienced a network issue.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -