Hello,
I'm new to mssql and php. I've taken over some php code that makes a query to a mssql DB. If the data returned is small enough, it works fine, but if it's too big, I get the following error:
Warning: mssql_query(): Query failed in c:\program files\apache group\apache\htdocs\monitoring\availability_corda.php on line 731
Fatal error: Call to undefined function: mssql_error() in c:\program files\apache group\apache\htdocs\monitoring\availability_corda.php on line 732
The problem is that the amount of data it's returning is not really that much -- maybe 5 columns by 100 rows. I think the problem may be the complicated computation that is being done on the DB side to return the data. I know some temp tables are being built on the fly and store procedures are being called.
Now, I've tried increasing the mssql timeout and the php memory limit.
Does anyone have any insight in to this problem? Any help is greatly appreciated.
Thanks!
