#22348 [Opn]: MSSQL.Timeout cannot be changed from default value.

ID: 22348 User updated by: jayc_lawrence at hotmail dot com Reported By: jayc_lawrence at hotmail dot com Status: Open Bug Type: MSSQL related Operating System: Windows 2000 SP3 PHP Version: 4.2.3 New Comment: Apologies.. i have sorted the problem, i was getting an execution time out which i assumed was the query timeout... this is not the case. I found the entry max_execution_time which appears to resolve my issue. So am i right in saying there are two timeouts, one for php rendering the page and the other for the return of records from a query of mssql (mssql.timeout). Sorry for the inconvenience. Previous Comments: ------------------------------------------------------------------------ [2003-02-21 05:04:00] jayc_lawrence at hotmail dot com Ok it says 90, so why are my queries timing out after 30 secs. Im going to recreate the database and see if my problem still occurs. However as i dont get any problems in query analyser, it is my assumption that there is something up with my code or php. ------------------------------------------------------------------------ [2003-02-21 03:50:16] sniper@php.net What does this output: <?php echo ini_get('mssql.timeout'); ?> ------------------------------------------------------------------------ [2003-02-21 03:22:08] jayc_lawrence at hotmail dot com Basically, ive tried changing the mssql.timeout to more than 30 seconds (even though i thought the default was 60?) as i have a query that works in query analyser, but gets a timeout on the php page. I changed it to 90, and it still timed out after 30 seconds. So i checked to see if php was reading php.ini, so i changed error_reporting to E_NOTICE to see if it successfully set it, and that worked. However mssql.timeout still doesnt. Ive restarted iis, rebooted the server... everything.. i dont believe this is the mssql server, ive checked all i can with that, and i dont use the windows odbc, i use the php_mssql.dll and also have php_gd.dll enabled. Im a bit stuck with this one, and wonder if theres a solution other than upgrading to the latest version.. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=22348&edit=1