Hi, We are running witango 5.0 with SQL Server2000 and wanted to do the same thing. We chose to have witango assign the desired query to a variable, save the variable to a table with the requesters info, then have sql server run a package every hour to process the queries and emails a notification with a link of the result file that is in a secure directory. This took the strain off of witango plus the sql package runs quicker than witango.
Ted -----Original Message----- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 12:49 PM To: '[EMAIL PROTECTED]' Subject: Witango-Talk: Size limit of database return OK, I know some of you are going to cringe, but is there a size limit of the amount of data that can be returned from a database call? Here's my situation. We have a corporate database which receives literally thousands of new records daily. We want to be able to allow people to query this database and if the number of records are less than, say, 10,000 display the records to them. If however, the file is larger we want to create the report, assign the data created in <@Results> to a variable, convert this file to an excel file, zip it up, and e-mail it to the requester. The problem we are running into seems to be size related. We believe that once the file reaches a certain size it causes either Witango or IIS to choke. We were timing out, but have upped the timeout period so that this is not the problem. Anyone know of any size issues that could be causing this program to issue a Client Error warning? Thanks in advance! Gene Wolf Business Systems Analyst, TLMN DRS Optronics, Inc. 2330 Commerce Park Drive Palm Bay, Florida 32905 Phone: 321-309-0685 E-mail: [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
