#9816 [Com]: FATAL: emalloc(): Unable to allocate
ri...@ednet.co.uk
Comment by: ri...@ednet.co.uk
Reported By: shaz...@usa.net
Status: Closed
Bug Type: ODBC related
Operating System: windows 2000 sp1
PHP Version: 4.0.5
New Comment:
I am seeing this problem. I have a script that connects to an Access
DB and then uses vtemplate to generate a page for the returns. It
works fine on w2k, IIS 5 (which is my development envirnoment) but when
I try exactly the same script & database on IIS4 on NT4 I get
--
The specified CGI application misbehaved by not returning a complete
set of HTTP headers. The headers it did return are:
FATAL: erealloc(): Unable to allocate 40 bytes
--
I would be v.gratefull if you could re-investigate this problem as it
still seems to be an issue.
thanks,
Rick.
Previous Comments:
------------------------------------------------------------------------
[2001-05-14 12:00:07] kalo...@php.net
as the user has discovered the problem is with the microsoft code, and
not the PHP code.
------------------------------------------------------------------------
[2001-05-11 14:54:41] shaz...@usa.net
This is a microsoft ODBC issue with Windows 2000 SP1, when you query
with concatenated fields it returns a size of 2GB. Read more at:
http://support.microsoft.com/support/kb/articles/Q272/9/51.ASP?LN=EN-US&SD=gn&FR=0&qry=SQLDescribeCol%20out%20of%20memory&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=MDAC
They haven't released a fix for it yet, It seems that you could check
to see if it returned 2GB. Do you think there is any chance of us
getting a patch for this?
------------------------------------------------------------------------
[2001-05-10 08:38:53] kalo...@php.net
user reports (btw please use the bug system):
*sigh*...Still fails in 4.0.5...thanks just the same. Let me know if
there's
anything else I can do...
tested on:
Windows 2000 Server, SP1
PHP4.0.5 CGI
IIS5
Access97, called using odbc_exec
query: "SELECT LastName & ', ' & FirstName AS pName FROM Borrowers"
error: FATAL: emalloc(): Unable to allocate 2147483599 bytes
------------------------------------------------------------------------
[2001-05-07 21:35:30] kalo...@php.net
Please try the recently released 4.0.5 to see if this is
corrected for you.
------------------------------------------------------------------------
[2001-04-29 22:49:00] shaz...@usa.net
I got the same error when I tried (in numerous ways) to get the
concatenation of two fields returned "AS" a new fieldname:
My example query:
SELECT BorrowerId, [FirstName] & [LastName] AS BName FROM Borrowers
causes:
FATAL: emalloc(): Unable to allocate 2147483599 bytes
I tried '+', '|', and '&' as concatenation operators, tried CONCAT(a,
b) -- I had heard that there was supposedly an internal odbc function
called CONCAT that's supposed to be driver independent, though I'm not
quite sure how that would work in practice -- and I even tried creating
an Access "Query"/View/StoredProcedure called BorrowerNames using the
query above. When I then issued a "SELECT * FROM BorrowerNames", I
still got the error.
Environment:
Windows 2000 Server, SP1
PHP 4.0.4pl1 (CGI)
Access 97
using odbc_exec() to Access 97 database
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/9816
--
Edit this bug report at http://bugs.php.net/?id=9816&edit=1