[freetds] One row good, two rows "memory exhausted"
Mark Bird
markabird at hotmail.com
Sat Sep 13 12:55:27 EDT 2008
Hello everyone,
I have set up PHP on linux and need to connect to a SQL Server 2000 server. I've installed FreeTDS version 0.82, PHP is able to make a connection to the database successfully, and, if I try to execute a query (using mssql_query) to get a recordset that returns only one record I am successful. However, if I try to return any more than one record, I get the dreaded "Allowed memory size of 134217728 bytes exhausted" error.
Here is my PHP configuration info: http://38.98.125.33/index.php
and here you can see the test page that throws the error: http://38.98.125.33/dbtest.php
Note that I have the default PHP maximum memory setting of 128 MB. Also, I've seen on the internet that this error often occurs when there are text fields being returned by the query, but there are no text fields in the table I'm querying here. In freetds.conf I have set tds version = 8.0 for this connection.
Thanks for taking a look, let me know there's any more information I can give.
Mark
_________________________________________________________________
Want to do more with Windows Live? Learn “10 hidden secrets” from Jamie.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008
More information about the FreeTDS
mailing list