On 10/30/08, Daniel Brown <[EMAIL PROTECTED]> wrote:
> On Thu, Oct 30, 2008 at 2:19 PM, Dan Shirah <[EMAIL PROTECTED]> wrote:
> >
> > Is it possible for us to use PHP to create temp tables in our database?
> [snip!]
> >
> > But all that does is give me an "ifx_prepare fails" message.
>    (Forwarded to PHP-DB as well.)
>    Dan, make sure Informix is set to allow that user to use the
> CREATE syntax.  Also, not sure about IFX, but with other SQL databases
> - including MySQL - you have to use the full word `TEMPORARY`, not
> just `TEMP`.
> --
> </Daniel P. Brown>
> http://www.parasane.net/
> Ask me about our current hosting/dedicated server deals!

Ah!  You both may be right.  I was running my entire using AQT and it ran
fine without any problems but once I pulled it into my web application it
took a swan dive.

You're probably totally right, of course it could create it in AQT because
I'm connecting to it with my credentials, whereas the web application is
connecting as a different user.

Thanks guys, I'll check out my permissions and hopefully that's all it is.

Just an FYI, the use of "temp" instead of "temporary" does work in Informix

Reply via email to