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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
teddynyambe
Forum Newbie
Posts: 1
Joined: Mon Oct 24, 2005 5:03 am

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

Post 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
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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?
Post Reply