nielsena54 Posted April 3, 2006 Share Posted April 3, 2006 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 TimeoutThe specified CGI application exceeded the allowed time for processing. The server has deleted the process."Thanks in advance! Quote Link to comment Share on other sites More sharing options...
Barand Posted April 3, 2006 Share Posted April 3, 2006 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 Link to comment Share on other sites More sharing options...
nielsena54 Posted April 4, 2006 Author Share Posted April 4, 2006 [!--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! Quote Link to comment Share on other sites More sharing options...
craygo Posted April 4, 2006 Share Posted April 4, 2006 Go here[a href=\"http://www.iis-resources.com/modules/AMS/article.php?storyid=76\" target=\"_blank\"]http://www.iis-resources.com/modules/AMS/a....php?storyid=76[/a]You can change the setting here, But sometimes It doesn't work. I had to do mine thru a dos command. I forgot how to do it but will post when I find it.Ray Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.