Page 1 of 1

Informix

Posted: Tue Aug 27, 2002 10:23 am
by Johnm
Is anyone in the group using an Informix database?

Direwolf

I use informix

Posted: Wed Jun 18, 2003 2:14 pm
by miller2300
I am using Informix, or atleast tying to at this point. I have PHP 4 running on my machine and it works great with MySQL running locally. Now, I am trying to connect to a remote Informix 7.x server and having problems.

I believe the PHP side is fine. I have the ifx extensions. I think the problem might by with my Client SDK SetNet32.

Anyone have an hints or experiences to share?

Error Message

Posted: Wed Jun 18, 2003 2:52 pm
by miller2300
OK, I think I was able to set up SetNet32 just fine.

Now when I make a connection to Informix, it still fails. I get the following error code and error message using ifx_error() and ifx_errormsg().

E [SQLSTATE=IX 001 SQLCODE=-1829]
Unable to load locale categories.

The Informix description of this error code is
Cannot open file citoxmsg.pam.
The file citoxmsg.pam is missing from the directory $INFORMIXDIR/msg.

But, I have this file and it is in the $INFORMIXDIR/msg directory.

Posted: Wed Jun 18, 2003 2:55 pm
by Johnm

Golden!

Posted: Wed Jun 18, 2003 3:09 pm
by miller2300
I had some erroneous setting in the [Informix] part of my php.ini.

It works now.

Posted: Wed Jun 18, 2003 3:22 pm
by cactus
If your Informix libs are on a *nix server, have you checked:
PHP Man wrote:The Informix shared libraries should also be available to the loader (check LD_LIBRARY_PATH or ld.so.conf/ldconfig).
Ref: http://uk.php.net/manual/en/ref.ifx.php

Also, you may need to set the path by:

Code: Select all

putenv("INFORMIXDIR=/path/to/Informix/directory/under/which/msg/lives/");
Ref: http://uk2.php.net/manual/en/function.putenv.php

With this caveat:
PHP Man wrote:These directives have only effect when safe-mode itself is enabled!
Or via a ".htaccess" file if you are using Apache:

SetEnv INFORMIXDIR /path/to/Informix/directory/under/which/msg/lives/

Ref : http://httpd.apache.org/docs/mod/mod_env.html

Regards,

Addition : Sorry, I posted too late, because it was a long ass winded reply ;) What was the OP's original question ?

Yes, I've worked with Informix/PHP, but not currently :)

Posted: Tue Jun 24, 2003 8:53 am
by Johnm
Did you get this problem resolved?

Posted: Tue Jun 24, 2003 9:49 am
by miller2300
Yes I did. Thank you. It was some settings I made in my PHP.ini file under the [Informix] section.