2. PHPRunner General questions
  3. [SOLVED]  PHP Runner - set OLEDB Timeout?
This topic is locked
[SOLVED]

 PHP Runner - set OLEDB Timeout?

 		10/18/2011 11:08:44 AM
PHPRunner General questions
G
 gluckett author

Hi, I have a large update (with a trigger). But it timesout too soon in PHPRunner:
<<< Record was NOT edited >>>

Source: Microsoft OLE DB Provider for SQL Server

Description: Query timeout expired


Where do I increase the timeout? I changed the PHP.ini setting.

mssql.timeout = 999

no effect.
Changed the default timeout in SQL Server

Remote Query Timeout 0=no timeout

no effect.
Checked Apache conf file...no luck
Any hints?
Admin 10/19/2011

If you use PHPRunner 5.3 and your web server runs under Windows you can try to modify include/dbconnection.php file. See my changes in bold.

function db_query($qstring,$conn)

{

global $strLastSQL,$dDebug;

if ($dDebug===true)

echo $qstring."
";

$strLastSQL=$qstring;

try{

$conn->CommandTimeout = 0;

return $conn->Execute($qstring);

} catch(com_exception $e)

{

trigger_error($e->getMessage(),E_USER_ERROR);

}

}