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"" <[EMAIL PROTECTED]> wrote in message
000301c0b2b0$08ae9020$[EMAIL PROTECTED]">news:000301c0b2b0$08ae9020$[EMAIL PROTECTED]...
> 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:[EMAIL PROTECTED]
> internet: http://www.suchtreffer.de
> _______________________________________________________________
>
>
>
> > -----Original Message-----
> > From: Denis Eltsov [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 22, 2001 8:00 AM
> > To: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> >
>
>
> --
> PHP Database 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 Database 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]
