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

Last Reply on Jun 06, 2012 08:36 AM By Mudassar

Posted on Jun 06, 2012 01:50 AM

I am making a website in which i need to load xml file from url.i am getting the into dataset but it is not able to save into database.i am getting the following error....

 

A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

 

below is my private method which i had been calling from page load

 

 

private void filloperatorcode()
{
    DataSet ds = new DataSet();
    SqlDataAdapter da;
    SqlConnection con;
    con = new SqlConnection(@"Data Source=;Initial Catalog=;Integrated Security=True");
    ds.ReadXml("http://letitgo.asia/api/serviceData.go?apimode=test&goid=5011000001&password=test123&rtype=xml");
    SqlBulkCopy sbc = new SqlBulkCopy("Data Source=.;Initial Catalog=test;Integrated Security=True");
    sbc.DestinationTableName = "r_servicefamily";
    con.Open();
    sbc.WriteToServer(ds.Tables[0]);   //This is the place where i am getting the error
    DropDownList1.DataTextField = "service_family";
    DropDownList1.DataValueField = "service_family";
    DropDownList1.DataSource = ds;
    DropDownList1.DataBind();
    
 	
}

 

Posted on Jun 06, 2012 08:36 AM

As said before the connection string has problem

 con = new SqlConnection(@"Data Source=;Initial Catalog=;Integrated Security=True");

 

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html