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

  • Question

  • 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.i am using sql server 2005

    private void filldthoperator()
    {
     	DataSet ds;
        SqlDataAdapter da;
        SqlConnection con;
        ds = new DataSet();
        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&service_family=02");
        SqlBulkCopy sbc = new SqlBulkCopy("Data Source=.;Initial Catalog=test;Integrated Security=True");
        sbc.DestinationTableName="r_dthcodes";
        con.Open();
        sbc.WriteToServer(ds.Tables[0]);//this is the line where i am getting the error
        DropDownList5.DataTextField = "operator_name";
        DropDownList5.DataValueField = "operator_name";
        DropDownList5.DataSource = ds;
        DropDownList5.DataBind();   
        
        
    }


    • Edited by RounakRana Wednesday, June 6, 2012 8:34 AM
    Wednesday, June 6, 2012 8:32 AM

Answers

  • Go to command prompt

    type "net start mssqlserver" then press enter.

    Your sql server will get started.

    • Proposed as answer by amber zhang Thursday, June 7, 2012 1:50 AM
    • Marked as answer by amber zhang Thursday, June 14, 2012 1:53 AM
    Wednesday, June 6, 2012 12:43 PM

All replies

  • Make sure MS SQL Server service is running up :-)

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Wednesday, June 6, 2012 8:39 AM
    Answerer
  • srry i did'nt get it.....running up...
    Wednesday, June 6, 2012 9:59 AM
  • i am getting the following error in ur blog

    Sorry, the page you were looking for in this blog does not exist.

    Wednesday, June 6, 2012 10:05 AM
  • I meant check out if SQL Server is running....Perhaps someone stopped it?

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Wednesday, June 6, 2012 10:59 AM
    Answerer
  • Go to command prompt

    type "net start mssqlserver" then press enter.

    Your sql server will get started.

    • Proposed as answer by amber zhang Thursday, June 7, 2012 1:50 AM
    • Marked as answer by amber zhang Thursday, June 14, 2012 1:53 AM
    Wednesday, June 6, 2012 12:43 PM