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?
> > 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>
> [EMAIL PROTECTED] || [EMAIL PROTECTED]
> 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