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

Article Source: Monx Digital Library

Copyrighted@ Monx Digital Library, otherwise stated
Use of our service is protected by our Terms of Use

Back To Previous Page ...