"A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)"

Question

i am facing  "(A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)" problem when i try to insert a bulk of data into database and trying to solve with  reference of blog but with unlock i did not find satisfying answer that exactly described my problem  ....

i am using windows server 2003,sql server 2008 in server and visual studio 2010 for c# coding ...

Regards 

Bibek Gautam 

Nepal,Kathmandu

---

Bibek

Answer 1

Hi Bibek,

Check if the following link helps.

http://blogs.msdn.com/b/spike/archive/2009/04/16/a-transport-level-error-has-occurred-when-sending-the-request-to-the-server-provider-tcp-provider-error-0-an-existing-connection-was-forcibly-closed-by-the-remote-host.aspx

Best Regards,

---

Bob Wu [MSFT]
MSDN Community Support | Feedback to us