I have set up PHP 5.0.1 on one of our test windows test servers, and I am having no trouble connecting to our mysql databases, but the informix connections have been nothing but trouble.
First of all, if you have PHP 5.0.0 and are trying to connect to informix, upgrade to the newest release. 5.0.0 had some kind of problem with the informix module (error loading php_ifx.dll, I believe). This was fixed in 5.0.1.
Now that I'm past that hurdle, all I get on the informix connection is error -25560 (connection failure). For some reason, it's unable to find or connect to our database. Here's my connection string:
$cn=ifx_connect("dbname@servername","user","password");
the database is in the sqlhosts.dat file:
servername olsoctcp 192.168.10.21 sql_turbo
The informix sdk is installed on the webserver and the informix bin directory is in the path:
C:\Program Files\Windows Resource Kits\Tools\;C:\Perl\bin\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Informix\Client-SDK\bin;"C:\Program Files\Log Parser 2.2 BETA\
Our webserver is IIS on Windows Server 2003 and the database box HPUX 11.0.
I know I'm missing something, but I can't find any relevant answers on the web. I assume it's something I haven't configured properly yet. The error says I haven't set INFORMIXSERVER. Should that be setup in my php.ini file? Do I also need to set INFORMIDIR, and if so is that the directory on the webserver or the databaseserver? Or is this an entirely different problem?
