|Article Time Stamp: 04 February 2009, 23:05:30 GMT+7|
PHP: MSSQL Query Fail Because Time Out
If a long query fails with the error "Query failed..." such as this:
[Tue Feb 03 16:56:42 2009] [error] [client 127.0.0.1] PHP Warning: mssql_query() [function.mssql-query]: Query failed in .....
Then you may want to increase the timeout in parsing mssql with one of 2 ways:
1. Set the timeout via ini_set('mssql.timeout', seconds)
2. Set the timeout in your php.ini, such as this:
mssql.timeout = 1600