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.