#22348 [Fbk->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: Feedback +Status: Open Bug Type: MSSQL related Operating System: Windows 2000 SP3 PHP Version: 4.2.3 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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