When I try to concating columns in MS Access 2000 using PHP odbc_exec() function, the Apache server shows me "500 - Internal server error" page and in the Apache error log is this message:

[Tue Aug 08 13:54:04 2000] [error] [client 127.0.0.1] Premature end of script headers: c:/php4/php.exe
[Tue Aug 08 13:54:04 2000] [error] [client 127.0.0.1] FATAL:  emalloc():  Unable to allocate 2147483599 bytes

Before updating Windows 2000 with SP1, there was not this error. 

Sample script:

<?php

@$cn = odbc_connect("dns", "user", "pass");

$query = odbc_exec($cn, "SELECT name&surname AS people FROM users");

?>

Other SQL queries (without concating commands)works fine.


OS: Windows 2000 prof. with SP1
PHP: 4.0.1pl2 (standard Win32 binaries) - CGI
PHP.INI: PHP.INI-DIST renamed to C:\WINNT\PHP.INI
WWW: Apache 1.3.12 running as service


Maybe is something wrong in W2K SP1, not in PHP...


Best regards,

Jiri Kori