*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
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> ID: 9816
> Updated by: kalowsky
> Reported By: [EMAIL PROTECTED]
> Old-Status: Open
> Status: Feedback
> Bug Type: ODBC related
> Operating system:
> PHP Version: 4.0.4pl1
> Assigned To:
> Comments:
>
> Please try the recently released 4.0.5 to see if this is
> corrected for you.
>
> Previous Comments:
> --------------------------------------------------------------------------
-
>
> [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
>
>
>
> --------------------------------------------------------------------------
-
>
> [2001-04-27 08:32:09] [EMAIL PROTECTED]
> Another user commented:
>
> I just have read the bug-report 9816 at php.net and want to answer your
email.
>
> Yes, the users are right: I had the same problems with FATAL:emalloc()
using the same odbc-queries to get information out of two ms access tables.
The first table only contains Customer-ID and pasword, the second contains
customer adress and a remark-field (data type memo)
>
> Tests:
> user authentication for login taken from table 1 -> OK
> hello text for user from table 2 -> FATAL:emalloc()
>
> Result of Test enviroment - after some nights of installation :-) :
>
> 1) Win2000, MS Access2000, IIS5 and PHP4.0.4 : FATAL:emalloc()
> 2) Win2000, MS Access2000 SP1, IIS5 and PHP4.0.4 : FATL:emalloc()
> 3) Win2000, MS Access2000 SP1, Apache 1.3 and PHP 4.0.4 : FATAL:emalloc()
>
> 4) Win NT 4, MS Access2000, IIS4 and PHP 4.0.4: OK, no errors
> 5) Win NT 4, MS Access2000, Apache 1.3 and PHP 4.0.4: OK, no errors
>
> The next days I try to debug the source code to find out what the trigger
of emalloc() realy is. Our new Webserver should be a Win2000 Server with
Apache and PHP. Therefore we need to know where the emalloc() error comes
from.
>
> If you want know our results of debugging please send me an email to
[EMAIL PROTECTED]
>
> --------------------------------------------------------------------------
-
>
> [2001-04-16 22:54:23] [EMAIL PROTECTED]
> Can someone with access to Windows2000 please test this out and either
confirm or deny this report? User reports this won't happen under Win98SE
and that is currently all I have access to...
>
> --------------------------------------------------------------------------
-
>
> [2001-04-03 07:50:46] [EMAIL PROTECTED]
> I am sorry but I have no coments on you ...
> In all versions from 4.0.2 till 4.0.4pl1.
> Only in win2000 with srvice pack 1 installed.
> Only, not in 95,98,me,nt and win2000 with out service pack 1.
> This script
> <?
> $a=odbc_connect("oh","","");
> $r=odbc_prepare($a,"SELECT 'a' FROM xx");
> odbc_execute($r);
> odbc_free_result($r);
> odbc_close($a);
> ?>
> where
> xx is a table whith 1 integer field and 1 row.
> and oh is odbc system dsn for ms access file with only one table (xx).
> I get FATAL: emalloc(): Unable to allocate 2147483599 bytes
>
>
> --------------------------------------------------------------------------
-
>
> [2001-04-01 20:40:00] [EMAIL PROTECTED]
> A) Unable to reproduce locally on Win98SE, and MSAccess
> with 4.0.5RC4
>
> B) which version of PHP are you using? Bug report says
> 4.0.4pl1, but your sample script suggests 4.0.2 -
> 4.0.1pl1... which is it?
>
> --------------------------------------------------------------------------
-
>
> The remainder of the comments for this report are too long. To view the
rest of the comments, please view the bug report online.
>
>
> ATTENTION! Do NOT reply to this email!
> To reply, use the web interface found at
http://bugs.php.net/?id=9816&edit=2
>
>
> --
> PHP Development Mailing List <http://www.php.net/>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
