ID: 9816 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] as the user has discovered the problem is with the microsoft code, and not the PHP code. ------------------------------------------------------------------------ [2001-05-11 14:54:41] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] Please try the recently released 4.0.5 to see if this is corrected for you. ------------------------------------------------------------------------ [2001-04-29 22:49:00] [EMAIL PROTECTED] 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
