Connection Interrupted issue

Last post 08-26-2009 5:00 AM by Thomas Sun – MSFT. 4 replies.

Sort Posts:

  • Connection Interrupted issue

    08-21-2009, 5:18 AM
    • All-Star
      20,984 point All-Star
    • venkatu2005
    • Member since 07-01-2008, 10:48 AM
    • Posts 4,558

    Connection Interrupted

    Wat I am doing here is , i am uploading the excel file and store it on Folder 

    Then i am getting the data from excel sheet Stored in DataSet -

    from that i am reading the data by each row and store it in database  ,

    its working in localhost but it was not working ,

    when i upload to server..? Why i got the error ?

    I have Changed My Blog from (http://venkat-dotnetsamples.blogspot.com) to (http://venkat-dotnetsnippets.blogspot.com)

    Regards,
    Venkatesan.M

    Please Mark as Answered If its helpful and Un-Mark as Answered if it not help u.
  • Re: Connection Interrupted issue

    08-21-2009, 8:55 AM

    Hello,

    What type of error have you received? How do you get the date from excel, have you used some MS Office ActiveX control? If yes, have you installed it on the server?

    Regards

  • Re: Connection Interrupted issue

    08-21-2009, 8:58 AM
    • Contributor
      2,103 point Contributor
    • realfantasy
    • Member since 12-02-2007, 9:06 AM
    • Lahore, Pakistan
    • Posts 309

    what error you are getting

    please post error and code 

    make sure you are setting correct path technique. to get that file you need to set absolute path rather relative path. 

    and make sure you have office driver installed on hosting machine

  • Re: Connection Interrupted issue

    08-24-2009, 1:32 AM
    • All-Star
      20,984 point All-Star
    • venkatu2005
    • Member since 07-01-2008, 10:48 AM
    • Posts 4,558

    HostingASPNet:
    What type of error have you received? How do you get the date from excel, have you used some MS Office ActiveX control? If yes, have you installed it on the server?

    I have not used any activex Control

    this is sample code

    Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/File/" & filepath) & "; Extended Properties=""Excel 8.0;"""
                        'Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filepath & "; Extended Properties=""Excel 8.0;"""
    
    
                        ''You must use the $ after the object you reference in the spreadsheet
                        Dim Group_Data As New OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
                        Group_Data.TableMappings.Add("Table", "ExcelTest")
                        Group_Data.Fill(Group_Dataset)


    From the dataset , we will retrieve the each row data and stored in database.

    it has not show any error but page show like this.

    Connection Interrupted
        
    The connection to the server was reset while the page was loading.
       
    The network link was interrupted while negotiating a connection. Please try again.

    Any solution pls....,

    I have Changed My Blog from (http://venkat-dotnetsamples.blogspot.com) to (http://venkat-dotnetsnippets.blogspot.com)

    Regards,
    Venkatesan.M

    Please Mark as Answered If its helpful and Un-Mark as Answered if it not help u.
  • Re: Connection Interrupted issue

    08-26-2009, 5:00 AM

     Hi,

    To better understand your issue, please confirm the following information:

    When did you get the error message above, trying to upload excel file to server or read data from excel file on server?

    If it occurs when you upload file, how large the excel file is? By default ASP.NET only allows to upload file less than 4 Mb.

    If you try to use another browser, does it have the same issue?

     

    I look forward to receiving your test results.

     

    Thomas Sun
    Microsoft Online Community Support

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question.
Page 1 of 1 (5 items)