Page 1 of 1

"Warning: mssql_query(): Query failed in "...error

Posted: Mon Oct 24, 2005 5:11 am
by teddynyambe
I have a database connection to Microsoft SQL Server processing quiet a huge ammount of information using mssql_pconnect(), but after a while the server is returning...

Warning: mssql_query(): Query failed in d:\program files\apache\apache\htdocs\timeserieshost\DisplayGrid.php on line 224

I have try to execute the actual query in SQL Analyzer, and the results are coming out but taking about 1min 17s.

I have increade the time out for PHP but still no success. Anyone who can assist?

Kind regards

Tedy L

Posted: Fri Oct 28, 2005 12:35 am
by RobertGonzalez
Is there a timeout setting for SQL Server? And how much data (records wise) are you pulling from this query? Is that much data necessary for a single query or can it be broken down into parts?