[wdvltalk] Re: Data set is too big

2003-11-14 Thread Furry, Tim
Bill wrote: When the output is a html table it says: Provider error '80004005' Unspecified error /myreport.asp, line 644 line 644 is: objRS.movefirst (goto the first line in the record set) When the output is excel the error occurs after you accept the file download: Internet

[wdvltalk] Re: Data set is too big

2003-11-14 Thread Bill Mais
Hi Tim, Thanks for the thorough answer. We are SQL 7 with all the sp's. The machine is muy macho with 4 processors and 1.5G ram. I'm creating the where statement on the fly and a report will run fine if the query result is small, but fail when the query result is big. And you can run the query