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] [EMAIL PROTECTED]
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
