The client error you are seeing I suspect is the client timing out before the server is done. Try increasing the clientiotimeout= in clients.ini. I typically set mine to be 1 second larger than the querytimeout.
Also check your Witango log to make sure the request is completing. Robert -----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
