Hi all
This is the first time I have tried to connect to INFORMIX from PHP.
I installed the client and successfully compiled in the latest ver. of PHP.
I need to connect to a remote box running INFORMIX SE to a database csdb under /home/cserver/cdb
On the database box, the sqlhosts looks like this:
local_se sesoctcp dms sqlexec
I set up the environment variables INFORMIXSERVER=local_se and INFORMIXDIR=/opt/informix (this is where the client is installed on the local box) on the web server. I also configured my client's sqlhosts like the one above and also made sure to configure /etc/services
I fire off
$connection = ifx_connect("csdb@10.111.7.146", "user", "pass") or die ("Could not connect to the DMS");
and keep getting:
Warning: ifx_connect: E [SQLSTATE=IX 000 SQLCODE=-25555
I have a funny feeling that I am getting the database name/INFORMIXSERVER mixed up or something, or maybe I need to specify the DBPATH? If so how do I reference DBPATH to a remote machine?
<sigh>
help! :-)