RE: Re: [PHP-DB] FATAL: emalloc(): Unable to allocate 2147483599 bytes

Nope, your syntax is wrong! "foo" is used to indicate a case-sensitive schema object name (user, table, field) etc: e.g. SELECT "MyTable"."MyField" FROM "MyTable" "MyTable" and "mytable" are treated as two separate entities. 'foo' is used to represent a string literal: SELECT "MyTable"."MyField" FROM "MyTable" WHERE "MyTable"."MyField" LIKE 'bar%' Anyway, back to your original problem. Have you installed/re-installed the latest NT service pack after you installed SQL Server and installed the latest SQL Server 2000 service pack? Bet ya didn't ;-) _____ ~ Richard Allsebrook ~ Applications Developer and Webmaster Easysoft Limited, Thorp Arch Grange, Thorp Arch, Wetherby, LS23 7BA, UK http://www.easysoft.com <http://www.easysoft.com> - http://www.cinema.com <http://www.cinema.com> "A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila." _____ -----Original Message----- From: eltsov [mailto:eltsov@lumena.ru] Sent: Thursday, March 22, 2001 4:32 PM To: php-db Cc: eltsov Subject: FW: Re: [PHP-DB] FATAL: emalloc(): Unable to allocate 2147483599 bytes No this not solves the problem Unfortunatly it's not the sintax problem. because Everything was fine until I setup SQL Server 2000 Best Regards Denis Eltsov ""Michael Rudel"" <mru@suchtreffer.de> wrote in message news:000301c0b2b0$08ae9020$2c00a8c0@suchtreffer.de... > Hi Denis, > > try this one: > > $r=odbc_exec($x,"select 'a' as a_leter from some_table"); > > or > > $r=odbc_exec($x,"select \"a\" as a_leter from some_table"); > > which you prefer, but you have to escape the "" within a ""-String !! > > Hope this solves your problem. > > Greetinx, > Mike > > Michael Rudel > - Web-Development, Systemadministration - > _______________________________________________________________ > > Suchtreffer AG > Bleicherstraße 20 > D-78467 Konstanz > Germany > fon: +49-(0)7531-89207-17 > fax: +49-(0)7531-89207-13 > e-mail: mailto:mru@suchtreffer.de > internet: http://www.suchtreffer.de > _______________________________________________________________ > > > > > -----Original Message----- > > From: Denis Eltsov [mailto:eltsov@lumena.ru] > > Sent: Thursday, March 22, 2001 8:00 AM > > To: php-db@lists.php.net > > Subject: [PHP-DB] FATAL: emalloc(): Unable to allocate > > 2147483599 bytes > > > > > > I use IIS5 - php4 (as CGI) - odbc connection to Access 2000 > > > > Everything was fine until I install MS SQL 2000 to the same machine. > > > > After this I receive such a message > > > > > > > > FATAL: emalloc(): Unable to allocate 2147483599 bytes > > > > > > > > every time I try to execute such a program > > > > <? > > > > $x=odbc_connect("oh","",""); > > > > $r=odbc_exec($x,"select "a" as a_leter from some_table"); > > > > ?> > > > > or > > > > <? > > > > $x=odbc_connect("oh","",""); > > > > $r=odbc_exec($x,"select format("dd.mm.yyyy",date_field) from > > some_table"); > > > > ?> > > > > > > > > Best regards Denis Eltsov > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

Attachment: [application/rtf]