Jump to content

CGI Timeout on IIS driving me nuts! Can't get it to leave -- help appreciated.


nielsena54

Recommended Posts

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!
Link to comment
Share on other sites

[!--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!
Link to comment
Share on other sites

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
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.