Solved

FastCGI Timeout when connecting with PHP on IIS to a stored proceedure in MSSQL using ODBC

Posted on 2008-10-29
2
3,204 Views
Last Modified: 2012-08-13
Hi, I've got a script that is running a stored procedure in MSSQL.  The first command prepares the data (it was made for me by the database guy, so I don't know what it does) and is supposed to take 5 minutes to run.  When my PHP script runs it I get a timeout error:

FastCGI Error
The FastCGI Handler was unable to process the request.
--------------------------------------------------------------------------------
Error Details:
The FastCGI process exceeded configured activity timeout
Error Number: 258 (0x80070102).
Error Description: The wait operation timed out.
HTTP Error 500 - Server Error.
Internet Information Services (IIS)

The server guy said he fixed it but obviously did not.  Is this the default_socket_timeout parameter in the PHP.ini at work here?
0
Comment
Question by:bakum
2 Comments
 
LVL 13

Accepted Solution

by:
Xyptilon2 earned 500 total points
Comment Utility
This guy had the same problem and was able to change some settings: I hope it is useful for you: http://forums.iis.net/t/1076662.aspx
0
 

Author Comment

by:bakum
Comment Utility
I had to do some extra work to figure out how to config fcgiext.ini correctly, but once that was done, it all worked out.

Thanks!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now