nielsena54

[!--quoteo(post=361405:date=Apr 3 2006, 05:51 PM:name=Barand)--][div class=\'quotetop\']QUOTE(Barand @ Apr 3 2006, 05:51 PM) [snapback]361405[/snapback][/div][div class=\'quotemain\'][!--quotec--] I wouldn't attempt to import that many recs through a web script. Do it off-line. What are you importing to and from - there may be a quicker method? [/quote] I am importing from Dataflex using an ODBC driver. I am doing it offline in the sense that it is on an intranet, definitely not a public script. This is the most efficient method that I have found so far; any other transfer options cost a whole lot of money because of the unique nature of DataFlex. As I'm writing this, I am realizing that I could maybe use Access with the same ODBC driver.... and make something work that way.... Anyway, I am still curious as to how to get rid of this cgi timeout error. In the meantime, I will either use a local Apache server on the same network or try some Access methods. thanks!

Hey all, I am writing PHP scripts to do some data transfer. One of the tables that I am importing is 400000+ records long. My challenge is avoiding the CGI timeout error in IIS. After 5 minutes it displays, no matter what I do. I have already used MetaBase to change the default value to a high number (24 hrs, or 86400 seconds). I have also changed the property in the IIS Manager GUI to reflect this change. I have restarted the server and the computer multiple times, but to no avail. I would just switch to Apache, except that I am transferring data into Microsoft SQL on a Microsoft Server running IIS .Net web services. The exact error reads: "CGI Timeout The specified CGI application exceeded the allowed time for processing. The server has deleted the process." Thanks in advance!