Thank you in advance for taking the time to read this.
I have a C# ASP.NET page that allows users to select 2 excel files from their machine and click a button to compare and look for differences. Any difference is output to a gridview for them to review. The code works brilliantly on my machine, on other machines inside our network, ect but when we try to access this page from outside the network and use excel file sizes around 1mb a piece, we're seeing a connection timed out error in IE (v6 and v7).
Due to limitations beyond my control, I can not save the files to the server first and then do my comparison code. Instead I have to read the files to memory and am using a .dll found here, http://exceldatareader.codeplex.com/. It basically reads the excel files into datasets, which are then passed on to my comparison method.
What appears to happen is that the comparison code takes some time, depending on the file size. For example, 20kb Excel files net results with no errors in just a few seconds. 200kb files take longer but still succeed. 1mb files, though, get the connection timed out but only in IE and only outside our network.
So my thought was that perhaps the browser isn't getting the results back from the server fast enough and issues the connecti
View Complete Post