Re: FATAL: emalloc() error

I'm passing odbe_exec() an ODBC connection ID (returned from odbc_connect()) and a SQL command that pulls several fields from a query in an Access database. Playing with it, I've determined that removing certain fields from my SQL command (not SELECT'ing them) will allow it to work. These fields are composed of other fields, joined together in the Access query (e.g. [Location] & [Sublocation]). I tried doing the join directly in my PHP SQL command ("SELECT [Location] & [Sublocation] AS Local FROM [Test Query] "), but this fails with: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecDirect in... I'm not sure what the problem is here. Does the ODBC Access driver not support "AS" or is the syntax differet? Any tips on how to get it to join these fields that will work, either in Access or my SQL SELECT command? Justin On Thu, 11 Jan 2001, Richard Lynch wrote: > What arguments are you passing to odbc_exec()? > > ----- Original Message ----- > From: Justin Smith <jthsmith@unm.edu> > Newsgroups: php.general > Sent: Tuesday, January 09, 2001 1:07 PM > Subject: [PHP] FATAL: emalloc() error > > > > I'm trying to query an MS Access database via ODBC, but the odbc_exec > > command fails with this error: > > > > FATAL: emalloc(): Unable to allocate 2147483599 bytes > > > > I don't know why it could possibly be trying to allocate 2GB, as the > > database is only about 4MB. Any suggestions would be appreciated. Justin Smith New Mexico Natural Heritage Program University of New Mexico Department of Biology 167 Castetter Hall Albuquerque, New Mexico 87131 505-277-3822 x226 505-277-3844 (fax) jthsmith@unm.edu