473,322 Members | 1,431 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How to create a large file with ASP.Net

I'm trying to develop a webapp for an intranet application (meaning that
bandwidth isn't an issue) that creates a large file, which takes a while.
Basically the app runs about 8 stored procedures, dumps all of the output
into a file, and does a Response.Redirect to that file. This worked well
before when I was creating a much smaller file, but this process takes about
5 minutes to complete and creates about a 15mb file. Everything goes fine
for a while, but then IE pops up a login & password box, which is really
weird, but I think it basically gives up waiting for the page to load while
all of the stuff is running, and never makes it to the Response.Redirect.
The interesting thing is that if I check in the folder after about 5 minutes,
the file is there and complete. It's just a matter of getting IE (or
ASP.Net, I'm not sure which is timing out, but I have increased the
SessionState timeout to 20 min) to stop from timing out before the redirect
happens. Thanks.
Nov 19 '05 #1
6 1363
so what's the question ?
"Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in message
news:29**********************************@microsof t.com...
I'm trying to develop a webapp for an intranet application (meaning that
bandwidth isn't an issue) that creates a large file, which takes a while.
Basically the app runs about 8 stored procedures, dumps all of the output
into a file, and does a Response.Redirect to that file. This worked well
before when I was creating a much smaller file, but this process takes
about
5 minutes to complete and creates about a 15mb file. Everything goes fine
for a while, but then IE pops up a login & password box, which is really
weird, but I think it basically gives up waiting for the page to load
while
all of the stuff is running, and never makes it to the Response.Redirect.
The interesting thing is that if I check in the folder after about 5
minutes,
the file is there and complete. It's just a matter of getting IE (or
ASP.Net, I'm not sure which is timing out, but I have increased the
SessionState timeout to 20 min) to stop from timing out before the
redirect
happens. Thanks.

Nov 19 '05 #2
The question is what's going on ... why is IE popping up a login dialog and
why am I not just able to put the Response.Redirect after all of the calls
to the stored procedure that write to the text file?

Or does someone have a better suggestion for how to generate a large file
that takes a while?

"Jon Paal" wrote:
so what's the question ?
"Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in message
news:29**********************************@microsof t.com...
I'm trying to develop a webapp for an intranet application (meaning that
bandwidth isn't an issue) that creates a large file, which takes a while.
Basically the app runs about 8 stored procedures, dumps all of the output
into a file, and does a Response.Redirect to that file. This worked well
before when I was creating a much smaller file, but this process takes
about
5 minutes to complete and creates about a 15mb file. Everything goes fine
for a while, but then IE pops up a login & password box, which is really
weird, but I think it basically gives up waiting for the page to load
while
all of the stuff is running, and never makes it to the Response.Redirect.
The interesting thing is that if I check in the folder after about 5
minutes,
the file is there and complete. It's just a matter of getting IE (or
ASP.Net, I'm not sure which is timing out, but I have increased the
SessionState timeout to 20 min) to stop from timing out before the
redirect
happens. Thanks.


Nov 19 '05 #3
try another browser to see if the problem is browser dependent.
"Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in message
news:DD**********************************@microsof t.com...
The question is what's going on ... why is IE popping up a login dialog
and
why am I not just able to put the Response.Redirect after all of the
calls
to the stored procedure that write to the text file?

Or does someone have a better suggestion for how to generate a large file
that takes a while?

"Jon Paal" wrote:
so what's the question ?
"Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in message
news:29**********************************@microsof t.com...
> I'm trying to develop a webapp for an intranet application (meaning
> that
> bandwidth isn't an issue) that creates a large file, which takes a
> while.
> Basically the app runs about 8 stored procedures, dumps all of the
> output
> into a file, and does a Response.Redirect to that file. This worked
> well
> before when I was creating a much smaller file, but this process takes
> about
> 5 minutes to complete and creates about a 15mb file. Everything goes
> fine
> for a while, but then IE pops up a login & password box, which is
> really
> weird, but I think it basically gives up waiting for the page to load
> while
> all of the stuff is running, and never makes it to the
> Response.Redirect.
> The interesting thing is that if I check in the folder after about 5
> minutes,
> the file is there and complete. It's just a matter of getting IE (or
> ASP.Net, I'm not sure which is timing out, but I have increased the
> SessionState timeout to 20 min) to stop from timing out before the
> redirect
> happens. Thanks.


Nov 19 '05 #4
That really isn't an option since IE is used exclusively here. Everyone is
running the latest version, and I did try it on several machines.

"Jon Paal" wrote:
try another browser to see if the problem is browser dependent.
"Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in message
news:DD**********************************@microsof t.com...
The question is what's going on ... why is IE popping up a login dialog
and
why am I not just able to put the Response.Redirect after all of the
calls
to the stored procedure that write to the text file?

Or does someone have a better suggestion for how to generate a large file
that takes a while?

"Jon Paal" wrote:
so what's the question ?
"Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in message
news:29**********************************@microsof t.com...
> I'm trying to develop a webapp for an intranet application (meaning
> that
> bandwidth isn't an issue) that creates a large file, which takes a
> while.
> Basically the app runs about 8 stored procedures, dumps all of the
> output
> into a file, and does a Response.Redirect to that file. This worked
> well
> before when I was creating a much smaller file, but this process takes
> about
> 5 minutes to complete and creates about a 15mb file. Everything goes
> fine
> for a while, but then IE pops up a login & password box, which is
> really
> weird, but I think it basically gives up waiting for the page to load
> while
> all of the stuff is running, and never makes it to the
> Response.Redirect.
> The interesting thing is that if I check in the folder after about 5
> minutes,
> the file is there and complete. It's just a matter of getting IE (or
> ASP.Net, I'm not sure which is timing out, but I have increased the
> SessionState timeout to 20 min) to stop from timing out before the
> redirect
> happens. Thanks.


Nov 19 '05 #5
the browser will not reliably wait this long for a response. use one of the
progressbar solutions (google this newgroup for progressbar).

-- bruce (sqlwork.com)

"Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in message
news:29**********************************@microsof t.com...
I'm trying to develop a webapp for an intranet application (meaning that
bandwidth isn't an issue) that creates a large file, which takes a while.
Basically the app runs about 8 stored procedures, dumps all of the output
into a file, and does a Response.Redirect to that file. This worked well
before when I was creating a much smaller file, but this process takes
about
5 minutes to complete and creates about a 15mb file. Everything goes fine
for a while, but then IE pops up a login & password box, which is really
weird, but I think it basically gives up waiting for the page to load
while
all of the stuff is running, and never makes it to the Response.Redirect.
The interesting thing is that if I check in the folder after about 5
minutes,
the file is there and complete. It's just a matter of getting IE (or
ASP.Net, I'm not sure which is timing out, but I have increased the
SessionState timeout to 20 min) to stop from timing out before the
redirect
happens. Thanks.

Nov 19 '05 #6
Can you create the file and then email the user when it is finished being
created with a direct link to the file? We do this on internet application
we have for our maintenance downloads. The user requests the software and
then we bulid the download behind the scenes and then email them when it is
finished.

Russ
"Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in message
news:1C**********************************@microsof t.com...
That really isn't an option since IE is used exclusively here. Everyone
is
running the latest version, and I did try it on several machines.

"Jon Paal" wrote:
try another browser to see if the problem is browser dependent.
"Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in message
news:DD**********************************@microsof t.com...
> The question is what's going on ... why is IE popping up a login dialog
> and
> why am I not just able to put the Response.Redirect after all of the
> calls
> to the stored procedure that write to the text file?
>
> Or does someone have a better suggestion for how to generate a large
> file
> that takes a while?
>
> "Jon Paal" wrote:
>
>> so what's the question ?
>>
>>
>> "Stefan Wrobel" <St**********@discussions.microsoft.com> wrote in
>> message
>> news:29**********************************@microsof t.com...
>> > I'm trying to develop a webapp for an intranet application (meaning
>> > that
>> > bandwidth isn't an issue) that creates a large file, which takes a
>> > while.
>> > Basically the app runs about 8 stored procedures, dumps all of the
>> > output
>> > into a file, and does a Response.Redirect to that file. This worked
>> > well
>> > before when I was creating a much smaller file, but this process
>> > takes
>> > about
>> > 5 minutes to complete and creates about a 15mb file. Everything
>> > goes
>> > fine
>> > for a while, but then IE pops up a login & password box, which is
>> > really
>> > weird, but I think it basically gives up waiting for the page to
>> > load
>> > while
>> > all of the stuff is running, and never makes it to the
>> > Response.Redirect.
>> > The interesting thing is that if I check in the folder after about 5
>> > minutes,
>> > the file is there and complete. It's just a matter of getting IE
>> > (or
>> > ASP.Net, I'm not sure which is timing out, but I have increased the
>> > SessionState timeout to 20 min) to stop from timing out before the
>> > redirect
>> > happens. Thanks.
>>
>>
>>


Nov 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Frank Millman | last post by:
Hi all I need to generate potentially large reports from a database, and I want to offer the option of print preview before actually printing (using wxPython). I figure that the best way to...
9
by: Lauren Quantrell | last post by:
Is there a way to create a text file (such as a Windows Notepad file) by using a trigger on a table? What I want to do is to send a row of information to a table where the table: tblFileData has...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
5
by: Jacob | last post by:
Happy New Year! I'm writing a program that will need to store large amounts of data from several DataSets that I create at runtime (for information like email, calendar, etc...). The trick is...
8
by: David Thielen | last post by:
Hi; I need to be able to create a single xml node in utf-8 and do it efficiently as this is called a lot (reason below). What is the best way to do this? I need to end up with a string like...
5
by: Michael Sperlle | last post by:
Is it possible? Bestcrypt can supposedly be set up on linux, but it seems to need changes to the kernel before it can be installed, and I have no intention of going through whatever hell that would...
8
by: barb | last post by:
So that the world at large benefits from our efforts, here is one fully documented way to use Windows Irfanview freeware to create thumbnail web galleries (http://www.irfanview.com). STEP 1:...
34
by: Tom | last post by:
I'd greatly appreciate advice and code snippets on how to create a ram disk within a C/C++ program. I also need to be able to determine the free space. Thanks in advance for any help.
19
by: loudking | last post by:
Hello, all My manager told me to create a large file of 2GB The first 1GB is filled with "Hello" and the secod 1GB is filled with "World" Sorry to say that I don't know how to do that in...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.