[wdvltalk] Data set is too big
Bill wrote: I have an asp page that creates and runs a sql statement and sends the results back to the user as an excel file. It works really well until the data set gets too big - 1500 records. If the file is too big it crashes when downloading the excel file. I changed the page to build an html table instead and this crashes also. The error message indicates that it crashed trying to go to the first record - objRS.movefirst. Tim: Bill, what's the exact error message you're getting? Are you building an Excel file on the server and then downloading it to the browser, or dumping down data a record at a time? ___ Tim Furry Web Developer Foulston Siefkin LLP The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Data set is too big
Hi, I have an asp page that creates and runs a sql statement and sends the results back to the user as an excel file. It works really well until the data set gets too big - 1500 records. If the file is too big it crashes when downloading the excel file. I changed the page to build an html table instead and this crashes also. The error message indicates that it crashed trying to go to the first record - objRS.movefirst. My uneducated guess is the cache or buffer that it is building the dataset in is not big enough to store everything and stuff (technical wording) is getting pushed out. Is there a setting on the IIS server to increase the cache/buffer? Or something I need to do on the asp page? TIA Bill PS I'm hoping rudy will write a sql book for web programmers :-) The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]