Informix

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Johnm
Forum Contributor
Posts: 344
Joined: Mon May 13, 2002 12:05 pm
Location: Michigan, USA
Contact:

Informix

Post by Johnm »

Is anyone in the group using an Informix database?

Direwolf
User avatar
miller2300
Forum Newbie
Posts: 5
Joined: Wed Jun 18, 2003 2:14 pm
Location: Royersford, PA

I use informix

Post 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?
User avatar
miller2300
Forum Newbie
Posts: 5
Joined: Wed Jun 18, 2003 2:14 pm
Location: Royersford, PA

Error Message

Post 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.
User avatar
Johnm
Forum Contributor
Posts: 344
Joined: Mon May 13, 2002 12:05 pm
Location: Michigan, USA
Contact:

Post by Johnm »

User avatar
miller2300
Forum Newbie
Posts: 5
Joined: Wed Jun 18, 2003 2:14 pm
Location: Royersford, PA

Golden!

Post by miller2300 »

I had some erroneous setting in the [Informix] part of my php.ini.

It works now.
User avatar
cactus
Forum Regular
Posts: 343
Joined: Tue Jun 10, 2003 4:16 am
Location: UK

Post 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 :)
User avatar
Johnm
Forum Contributor
Posts: 344
Joined: Mon May 13, 2002 12:05 pm
Location: Michigan, USA
Contact:

Post by Johnm »

Did you get this problem resolved?
User avatar
miller2300
Forum Newbie
Posts: 5
Joined: Wed Jun 18, 2003 2:14 pm
Location: Royersford, PA

Post by miller2300 »

Yes I did. Thank you. It was some settings I made in my PHP.ini file under the [Informix] section.
Post Reply