Is anyone in the group using an Informix database?
Direwolf
Informix
Moderator: General Moderators
- miller2300
- Forum Newbie
- Posts: 5
- Joined: Wed Jun 18, 2003 2:14 pm
- Location: Royersford, PA
I use informix
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?
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?
- miller2300
- Forum Newbie
- Posts: 5
- Joined: Wed Jun 18, 2003 2:14 pm
- Location: Royersford, PA
Error Message
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.
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.
- miller2300
- Forum Newbie
- Posts: 5
- Joined: Wed Jun 18, 2003 2:14 pm
- Location: Royersford, PA
Golden!
I had some erroneous setting in the [Informix] part of my php.ini.
It works now.
It works now.
If your Informix libs are on a *nix server, have you checked:
Also, you may need to set the path by:
Ref: http://uk2.php.net/manual/en/function.putenv.php
With this caveat:
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
Ref: http://uk.php.net/manual/en/ref.ifx.phpPHP Man wrote:The Informix shared libraries should also be available to the loader (check LD_LIBRARY_PATH or ld.so.conf/ldconfig).
Also, you may need to set the path by:
Code: Select all
putenv("INFORMIXDIR=/path/to/Informix/directory/under/which/msg/lives/");With this caveat:
Or via a ".htaccess" file if you are using Apache:PHP Man wrote:These directives have only effect when safe-mode itself is enabled!
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
Yes, I've worked with Informix/PHP, but not currently
- miller2300
- Forum Newbie
- Posts: 5
- Joined: Wed Jun 18, 2003 2:14 pm
- Location: Royersford, PA