PHP and Informix: questions

martincrumlish

Hi,

I have a PHP 4.0.6 set up. i am not upgrading PHP at the moment. All of my existing apps are base don a mySQL DB however, some of the powers that be where i work have decided not to support mySQL and now I have to change everything across to informix.

The Informix DB is on a different server, what do I need to do to connect to it?

Do I just specify an ip address, username and password in the ifx_connect funtion or is there a special way that PHP needs to be set up? In the PHP/extensions directory php_ix.dll is already there

Nothsa

http://www.php.net/manual/en/function.ifx-connect.php

martincrumlish

Hi,

thanks for the reply. i have read that part of the manual. I also worked out what i need to install. Basically, a load of .dll files and some changes to php.ini

however, now when i try to connect i am getting this error:

Warning: ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829]

Any ideas?

Nothsa

I did a quick search for the error code. One guy says:

"That looks suspiciously like the error code I get when I haven't properly set my INFORMIXDIR and INFORMIXSERVER environment variables."

Two other people said to make sure that the informix server is running properly (have you tried to connect to it some other way?).

And the final one I found was from a guy who had the error and fixed it. His first post said it was working for a few days, then they rebooted the server and got that error, then a little later he wrote:

"Thanks

We found the bug, we need re-make the php and apache ( because we reinstall
Informix IDS) and remove all httpd in the PATH.

we have problems with PHPLIB`s db_informix.inc because we need do some
changes from the original version to get ready.
someone have a full operational version of db_informix.inc or some clue
about it."

I hope something in there helps =)